October 11, 2009 at 2:18 pm
I was just wondering , what are the differences / enhancements in SQL Server 2005 over SQL Server 2000 by view of DEVELOPER ( Not by DBA ) ? Because, in any version , s/he gonna write all sql stuffs (e.g. SPs, Functions etc. ), right ?:ermm:
Does anyone know ?:Whistling:
October 11, 2009 at 2:42 pm
see url
http://technet.microsoft.com/en-us/library/ms170363(SQL.90).aspx
---------------------------------------------------------------------
October 12, 2009 at 4:48 am
This might also help you, (developer perspective!)
---------------------------------------------------------------------------------
October 13, 2009 at 5:11 am
Hi,
Looking at this from another perspective, you could say that the difference is 5.
😛
Martin
October 13, 2009 at 6:28 am
webtekkie (10/13/2009)
Hi,Looking at this from another perspective, you could say that the difference is 5.
😛
Martin
Yeah that makes sense too from developer perspective, 5 major DML enhancements,
OUTPUT Keyword
Common Table Expressions
PIVOT and UNPIVOT Operators
APPLY
Ranking Functions
😉
---------------------------------------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply