Exact Difference between SQL Server 2000 and SQL Server 2005

[imago]

Hi,

Now I started learning SQL Server 2000. Perhaps, I want to update
myself simultaneously with SQL Server 2005 also. I want to know the
exact difference between SQL Server 2000 and SQL Server 2005 with
respect to programming and concepts....It will be helpful to me. I need
to use SQL as the back end for my .net projects. That's why.

Thanks.

[David Portas]

http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx
http://msdn2.microsoft.com/en-us/library/ms170363(SQL.90).aspx
http://msdn2.microsoft.com/en-us/library/ms143232(SQL.90).aspx

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

[imago]

David,

Now I am in a position to start working on SQL 2005, can u give me any
Ebooks or any good material.

You have sent me the link where I could find the new things added in
SQL 2K5. Is there any difference between SQL 2k vs. 2K5 with respect to
programming - query statement? kindly Let me know.

Imago

[Omnibuzz]

imago,
With respect to coding. Almost everything that runs on SQL Server 2000
runs on SQL Server 2k5. Except a few older syntax like using *= for join,
which was working in SQL Server 2000 just for backward compatibility, there
are no major changes in coding per se. A lot of new operations have been
added to 2k5 though, which I think u can find in the links given by david.
-omni

[David Portas]

The last two links I posted cover the TSQL programming changes.

[imago]

Thanks for every1. Definitely it would be useful to me. I have also
gone through the following link, where I could find some more clear
description.

http://www.c-sharpcorner.com/Longhorn/Yukon/FAQ-Yukon.asp

Tanx

[David Portas]

Clearer? Definitely not accurate though. That article is more than 2
years out of date!

[imago]

yaah.... Just now i noted it was posted during 2004. tanx 4 ur
intimation. I will start going through the links given by you. After
that I will post you if i have any query.