Exact Difference between SQL Server 2000 and SQL Server 2005

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.imago wrote:
> 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.
http://www.microsoft.com/sql/prodin...ibrary/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
--|||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|||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|||imago wrote:
> 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
The last two links I posted cover the TSQL programming changes.
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
--|||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/Longho...n/FAQ-Yukon.asp
Tanx|||imago wrote:
> 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/Longho...n/FAQ-Yukon.asp
> Tanx
Clearer? Definitely not accurate though. That article is more than 2
years out of date!
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
--|||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.