Use this tag for questions specific to the 2000 version of Microsoft's SQL Server.
I have a legacy business application built on MS SQL Server 2000. I have some webbased utilities that access this database …
sql-server-2000 upgrade compatibility php-5.3 sqlsrvGiven the following update statement: UPDATE @TableVariable SET city = T2.city FROM @TableVariable TV INNER JOIN dbo.TABLE_1 T1 WITH (…
sql-server sql-server-2000 nolock hintsI am building a view in SQL Server 2000 (and 2005) and I've noticed that the order of the join statements greatly …
sql-server sql-server-2005 optimization join sql-server-2000I need to export some data using SQL Server 2000's BCP utility. Sometimes my data contains characters, such as \t …
sql-server-2000 export escaping bcpI am using the Entity Framework in a web application that utilizes SQL server 2000, 2005, and 2008. When I create a new …
sql-server-2005 entity-framework sql-server-2000 entityI'm trying to alter a table to add a new column, then insert a new row into it. ALTER TABLE …
sql-server tsql sql-server-2000How do I fix up this part of my stored procedure? The select will either return 1, 0, or null. If the …
sql variables select sql-server-2000 coalesceWhat would be the most efficient way to do a paging query in SQLServer 2000? Where a "paging query" would be …
sql sql-server-2000 paging limitHow much fragmentation is bad? How low of scan density is too low? How low does scan density is bad? …
sql-server sql-server-2000 indexing fragmentation sql-server-performanceSELECT **FIELDS** AS [text()] --Stops the XMLPATH line rendering output as XML FROM #temp WHERE **CONDITIONS** FOR XML PATH('') …
sql sql-server-2005 tsql sql-server-2000 for-xml