Free online practice exercises on SQL/Oracle
I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

Answer Question   |  April 17, 2013  9:47 AM
MySQL, Oracle, SQL Server

SQL Server equivalent of Oracle’s desc tablename command
Thank you all for the response to my previous query. What is the T-SQL equivalent of Oracle’s desc command? I mean, what is the command in T-SQL to see the structure of a particular table? And what do we do in T-SQL if we want to see list of all the tables in a particular [...]

Answer Question   |  March 17, 2005  2:13 PM
Database Management Systems, MySQL, Oracle, SQL Server

Difference between SQL and T-SQL(Microsoft SQL Server 2000)
What is the difference between SQL and T-SQL(used by Microsoft SQL Server 2000)?

Answer Question   |  March 15, 2005  9:25 AM
Database Management Systems, DataCenter, MySQL, SQL Server

Difference between Sql Server 7 & Sql Server 2000
Hi, Can you tell me difference between Sql server 7 and Sql Server 2000?

Answer Question   |  March 14, 2005  1:06 PM
Microsoft Windows, SQL, T-SQL

Oracle ./runInstaller problem
Dear Oracle Experts, I came across the following problem when trying to update my Oracle 9.2 to Oracle 9.2.0.4 When I typed > ./runInstaller for the Oracle 9.2.0.4 patch. I get the following error. “You do not have permission to write to the inventory /oracle/product/db/920/$ORACLE_HOME. Installation cannot continue.: Permission denied” The following environment are set [...]

Answer Question   |  March 25, 2005  11:19 PM
Database Management Systems, Oracle, Oracle 9i, Standard Edition

Convert date format from UTC to PST in SQL
HI Friends Is there any way to convert date format from UTC to PST? Thanks and Regards Ashu

Answer Question   |  March 10, 2005  3:30 AM
Database Management Systems, SQL Server, Standard Edition 2000, T-SQL

Database comparison
I know this is ‘cheating’ but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp’s etc. I think this can be done using systables, however i was wondering if anybody had done this and how [...]

Answer Question   |  March 10, 2005  4:21 PM
Database, DB2, Oracle, SQL Server, SQL Server 2000, T-SQL

Returning Multiple result sets to Excel
I need to return a full result set including a number of Sum(s) Max(s) etc to an excel spreadsheet (don’t ask why) from a Stored procedure on MS SQL2000. Problem is that Xcel can only handle a single result set per sheet… Any Ideas?

Answer Question   |  March 8, 2005  5:14 PM
SQL, T-SQL

Front-End Reporting Tools for Secure Web Service Application with MS-SQL server-2
Hi… We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small secure web service application for reporting purposes that will require minimal IT experise to build or maintain, and will deliver maximum performance in terms of response time and data [...]

Answer Question   |  March 7, 2005  10:03 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server

Front-End Reporting Tools for Secure Web Service Application with MS-SQL server
Hi… We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small web service application for reporting purposes that will require minimal IT experise to build or maintain. The back end RDBMS engine is built with MS SQL server and will [...]

Answer Question   |  March 2, 2005  9:49 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server

Calling all SQL Server experts!
My name is Catherine Ketcher; I am a TechTarget editor in the process of launching a new site targeted to IT professionals using MS SQL Server. I am looking for SQL Server experts to participate on the site. I need experts interested in writing tips and/or answering questions in our ‘Ask the Experts’ section (see [...]

Answer Question   |  February 25, 2005  12:40 PM
Administration, Implementation, SQL Server

Unix ODBC Drivers
I am looking for an inexpensive way to do a pull of Sqlserver data into Oracle using Native Oracle Sql Statements to select the data from Sqlserver. This request would be easy to fulfill if there were an ODBC driver for Unix. I have found such drivers but they are expensive ($4000 per CPU on [...]

Answer Question   |  February 21, 2005  11:25 AM
Hardware, Oracle 9i, SQL Server

T-SQL, and cascading updates or finding constraint names
Hi all, I have been tasked with a difficult project. My employer has a rather large database, hosted on SQL Server 2000, which is used by several thousand users across our organization, and grouped by business units. This database is evolving with each minor release, which is just about every month. On occasion, I’m asked [...]

Answer Question   |  February 18, 2005  10:09 AM
SQL, SQL Server, Standard Edition 2000

TopIndex property for .NET Web ListBox
I’m trying to automatically scroll down to the last inserted item in a multi-select ListBox when only a few of the total # of rows are visible. Windows.Forms ListBox control has a TopIndex property that allows you to do that, but there is no similar property for the Web control. Note: In a single selection [...]

Answer Question   |  January 22, 2005  9:44 AM
ASP, ASP.NET, C, DataCenter, Development, Hardware, HTML, Lifecycle development, Manufacturing applications, Perl, Programming Languages, Retail/point-of-sale applications, Special-purpose software, SQL, T-SQL, VB.NET, Web development tools, XML

SQL server developer
Is a server required, or can this be installed on XP Pro.

Answer Question   |  January 21, 2005  11:43 PM
SQL Server

Accessing SQL Server data-2
I need to access data on an SQL server from our AS/400. I need something quick and cheap. Help!

Answer Question   |  January 31, 2005  5:50 PM
SQL Server

Accessing SQL Server data
I need to access data on an SQL server from our AS/400. I need something quick and cheap. Help!

Answer Question   |  January 19, 2005  5:50 PM
SQL Server

Database choice for web application
I am building web applications, using ASP.NET, each of which must store/retrieve data to/from a set of central databases. I basically have a choice between using MS Access or SQL Server and could use some advice about which to go for or what criteria to apply. Bear in mind that there will be several databases [...]

Answer Question   |  January 24, 2005  4:28 AM
Database Management Systems, DataCenter, Development, SQL Server, Web development tools, Web services

SQL Website
Hello again. We have an internal web server that is built using SQL Developer 2000. THis is on our DMZ on the firewall. we can not link to it from our internal network to transfer data to the sql tables. to test i opened all traffice between dmz and the internal network to test and [...]

Answer Question   |  December 30, 2004  12:23 PM
SQL Server

Can’t register remote SQL 2000 server
We have fresh installs of XP Pro SP2 on several workstations in the same site and the same subnet done not from the image. We want to use TCP/IP to register the default instance of SQL 2000 server located behind the firewall, not in our site. Some of workstations have no problems registering the SQL [...]

Answer Question   |  January 3, 2005  5:36 PM
Security, Servers, SQL Server, SQL Server 2000