Use this tag for questions specific to the 2000 version of Microsoft's SQL Server.
I'm trying to better understand why one of our database update scripts failed to work properly at a particular customer …
sql sql-server permissions sql-server-2000I've got a table of invoices and a child table of related data related by key. In particular, for each …
sql-server tsql sql-server-2000When I run the sql query I got something like this : Disallowed implicit conversion from data type varchar to data …
sql-server sql-server-2000I need to convert Datetime fields to a specifically formatted INT type. For example, I want 2000-01-01 00:00:00.000 to convert …
tsql sql-server-2000I want to add a variable number of records in a table (days) And I've seen a neat solution for …
sql sql-server tsql sql-server-2000Is it possible to define a sort order for the returned results? I would like the sort order to be …
sql sql-server tsql sql-server-2000 sql-order-byI need to run a query against a legacy table that stores URL encoded text. I need this text to …
sql sql-server-2000 urldecodeI am making a few minor updates to a VB6 application. It runs on a windows 2000 server connected to a …
vb6 activex sql-server-2000 windows-server-2000I put together a sample scenario of my issue and I hope its enough for someone to point me in …
sql sql-server tsql sql-server-2000How can I export a table from a SQL Server 2000 database to a .sql file as a bunch of INSERT …
sql sql-server tsql sql-server-2000 data-export