Thursday, March 8, 2012

Changing queries for SQL Server 2000

I am currently using ASP as the front end and SQL Server 7.0 as backend. We are migrating SQL Server 7.0 to SQL Server 2000. How this will affect my queries used in the fron-end. Also as for as T-SQL is concerned what are all the changes happened in SQL Server 2000 (which is not there in SQL Server 7.0)?I think 2000 is pretty good backwards compatible with SQL 7.0 scripts, check out these pages for features in SQL 2K.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_00_1lbn.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/CoolestFeatures.asp

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part1/c0261.asp

HTH

No comments:

Post a Comment