Use this tag for questions specific to the 2000 version of Microsoft's SQL Server.
I have a SQL Server 2000 with a table containing an image column. How do I insert the binary data of …
sql-server tsql sql-server-2000What is the best way to replace all '<' with < in a given database column? Basically …
sql sql-server regex sql-server-2000I've got a query I'm working on and I want to increment one of the fields and restart the counter …
sql sql-server tsql sql-server-2000Can anyone find my error in this query? I'm using SQL Server 2000 and I want to update all entries in …
sql sql-server tsql sql-server-2000 sql-updateTable1 id 01 wire 02 steve ram123 03 .... from the table1 i want to select only numeric values, It should not display alphanumeric …
sql sql-server tsql sql-server-2000I need to make a temporary table that holds of range of dates, as well as a couple of columns …
sql tsql stored-procedures sql-server-2000Any suggestions how to join tables from different servers in stored procedure?
sql-server sql-server-2000How do I get structure of temp table then delete temp table. Is there a sp_helptext for temp tables? …
sql-server tsql sql-server-2000Simple question, as the title suggests: What is the syntax to drop a Stored Procedure (SP) in SQL Server 2000, by …
stored-procedures sql-server-2000 sql-dropHow does one detect whether a field is blank (not null) and then select another field if it is? What …
sql sql-server-2000