Exporting Data to Text/CSV file in SQL Server 6.5
Hi, I would like to know how do we Export Data to Text/CSV file in SQL Server 6.5 Do we have something similar to DTS in SQL Server 2000? Thanks, Kruti

Answer Question   |  March 24, 2005  3:37 PM
Database Management Systems, SQL Server

SQL Trigger to create .csv file
I need to create a .csv file out of table A upon the insertion of a record into table B. It seems to me that this should be easy to accomplish, but the only answer I can get from anyone is to do a scheduled DTS package, which means we are dumping this table every [...]

Answer Question   |  March 30, 2005  2:32 PM
SQL, SQL Server, SQL Server 2000

Accessing Linked Server in SQL Server 2000 (Urgent)
I have a server named say ‘SRVMAIN’. Using Enterprise Manager I added a linked server ‘LNKDSRVR1′ (existing server). I m able to access any database in ‘LNKDSRVR1′ by writing a query in query analyzer of ‘SRVMAIN’ as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as ‘linkedserver’. Again I added a linked server in [...]

Answer Question   |  March 24, 2005  10:47 PM
Administration, Availability, Backup & recovery, Biometrics, Digital certificates, Identity & Access Management, Migration, MySQL, Performance/Tuning, provisioning, Security, Security tokens, Servers, Single sign-on, SQL Server, SQL Server 2000, Standard Edition 2000, Tech support

Urgent!Please help: TOP 3 cities only returned based on count() – result
I have three tables: Country, City, Restaurant. I would like to have a query that first calculates how many restaurants are for each city. I would only want to return those three cities for each country which has the most number of restaurants. Country-table: countryid, countryname City-table: cityid, cityname Restaurant-table: restaurantid cityid countryid isactive Only [...]

Answer Question   |  March 30, 2005  3:04 PM
SQL, SQL Server, SQL Server 2000

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