Use this tag for questions specific to the 2000 version of Microsoft's SQL Server.
How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?
sql sql-server sql-server-2005 sql-server-2000I would like this to be the ultimate discussion on how to check if a table exists in SQL Server 2000/2005 …
sql-server tsql sql-server-2005 sql-server-2000I'll use a concrete, but hypothetical, example. Each Order normally has only one line item: Orders: OrderGUID OrderNumber ========= ============ {FFB2...} STL-7442…
sql sql-server tsql sql-server-2000I need a different random number for each row in my table. The following seemingly obvious code uses the same …
sql-server tsql sql-server-2000Is there a straightforward way of finding the index of the last occurrence of a string using SQL? I am …
sql-server string tsql search sql-server-2000Using SQL Server 2000, how can I get the first and last date of the current year? Expected Output: 01/01/2012 and 31/12/2012
sql sql-server sql-server-2000I generated script from old database, created a new database and imported all data from old database. So far so …
sql sql-server sql-server-2000I'm trying to get the last datetime record from a table that happens to store multiple status. My table looks …
sql sql-server datetime sql-server-2000Is it true that SQL Server 2000, you can not insert into a table variable using exec? I tried this script …
sql-server tsql sql-server-2000How can I get the records from a db where created date is today's date? SELECT [Title], [Firstname], [Surname], [Company_…
datetime sql-server-2000