Top "Sql-server-2000" questions

Use this tag for questions specific to the 2000 version of Microsoft's SQL Server.

how to get the next autoincrement value in sql

I am creating a winform application in c#.and using sql database. I have one table, employee_master, which has …

c# sql sql-server winforms sql-server-2000
t-sql replace on text field

I have hit a classic problem of needing to do a string replace on a text field in an sql 2000 …

sql-server sql-server-2000
Restore a SQL Server 2000 backup on SQL Server 2012

I have got following error message while restoring a backup from SQL Server 2000 to the latest version. I do not …

sql-server sql-server-2000 sql-server-2012
How do you return a constant from an sql statement?

How do I return a constant from an sql statement? For example how would I change the code below so "…

sql sql-server tsql sql-server-2000
SQL convert string to date format 112

I have an input date and I need to convert it to format 112 (yyyymmdd) for use later on in my …

sql sql-server tsql sql-server-2000 date-conversion
Find a stored procedure name with its content in SQL Server 2000

For a stored procedure, I have its full source code. But the name of that stored procedure has been lost. …

sql stored-procedures sql-server-2000
How to fix the embedded text qualifier issue while exporting data to CSV flat file?

RFC 4180: RFC 4180 defines Common Format and MIME Type for Comma-Separated Values (CSV) Files. One of the requirements of the RFC 4180 …

sql-server ssis sql-server-2000 sql-server-2012
SQL Scheduled job query, duration of last runs?

Previously used this SQL Agent Jobs, how to document to get information about all SQL Scheduled jobs. How can I …

sql-server tsql sql-server-2000
How do I limit a LEFT JOIN to the 1st result in SQL Server?

I have a bit of SQL that is almost doing what I want it to do. I'm working with three …

sql sql-server sql-server-2000 greatest-n-per-group
INSTEAD OF UPDATE Trigger - is this possible?

I am making some tweaks to a legacy application built on SQL Server 2000, needless to say I only want to …

sql sql-server sql-server-2000