Use this tag for questions specific to the 2000 version of Microsoft's SQL Server.
I have a stored procedure in SQL Server 2000 that performs a search based on parameter values. For one of the …
sql sql-server sql-server-2000I want to find all column names in all tables in all databases. Is there a query that can do …
sql sql-server tsql sql-server-2000 database-schemaPossible Duplicate: How to get the record of a table who contains the maximum value? I've got an aggregate query …
sql sql-server sql-server-2000How to get the time for a given datetime value? I have a datetime in database like this: 2010-09-06 17:07:28.170 …
sql-server tsql datetime sql-server-2000How can I exit in the middle of a stored procedure? I have a stored procedure where I want to …
sql-server tsql stored-procedures sql-server-2000 control-flowDoes anyone know of any way to list open transactions on SQL Server 2000 database? I am aware that I can …
sql sql-server transactions sql-server-2000I have two tables Table A: ID 1 2 3 4 Table B: ID 1 2 3 I have two requests: I want to select all rows …
sql sql-server-2000I know this must be simple, but how do I preface the creation of a function with a check to …
tsql sql-server-2000I realize that temporary tables are session/connection bound and not visible or accessible out of the session/connection. I …
sql sql-server sql-server-2000 temp-tablesI need, if possible, a t-sql query that, returning the values from an arbitrary table, also returns a incremental integer …
sql sql-server sql-server-2000 auto-increment row-number