Use this tag for questions specific to the 2000 version of Microsoft's SQL Server.
Our system runs on SQL Server 2000, and we are in the process of preparing for an upgrade to SQL Server 2008. …
sql-server tsql sql-server-2008 sql-server-2000 performanceI am creating a new table in Microsoft SQL server 2000 by writing the code instead of using the GUI, I …
tsql sql-server-2000 default constraintsI realize that parameterized SQL queries is the optimal way to sanitize user input when building queries that contain user …
sql security sql-server-2000 sql-injection sanitizationI want to check table PREMIUM_SERVICE_USER if any records exists for strClientID update timeValid for +30 if no records …
sql-server stored-procedures merge sql-server-2000 upserti'm trying to call a User-Defined Function (UDF) on a linked server: CREATE FUNCTION [dbo].[UserGroupMembershipNames](@UserGUID uniqueidentifier) RETURNS VARCHAR(8000) …
sql-server sql-server-2000 linked-server user-defined-functionsI made a view to abstract columns of different tables and pre-filter and pre-sort them. There is one column whose …
sql sql-server-2000I am using a SQL 2000 database. I am working with a database in which I cannot change the types on …
sql sql-server tsql sql-server-2000I have a stored procedure which executes a select statement. I would like my results ordered by a date field …
sql-server sql-server-2000I have a query doing something like: SELECT FieldX, FieldY FROM A WHERE FieldW IN (108, 109, 113, 138, 146, 160, 307, 314, 370, 371, 441, 454 ,457, 458, 479, 480, 485, 488, 490, 492, 519, 523, 525, 534, 539, 543, 546, 547, 550, 564, 573, 629, 642, 643, 649, 650, 651, 694, 698, 699, 761, 762, 768, 772, 773, 774, 775, 778, 784, 843, 844, 848, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 868, 869, 871, 872, 873, 891) Having an IN clause with …
sql sql-server-2000In T-SQL (SQL Server 2000). How can I list all tables and columns in a database? Also, in a separate query …
sql-server tsql sql-server-2000