Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 New Transact-SQL/query techniques of SQL 2005/2008

Author  Topic 

johnsql
Posting Yak Master

161 Posts

Posted - 2008-08-06 : 09:42:11
Hi,
I am looking for articles that detail new Transact-SQL or new query techniques of MS SQL Server 2005, 2008. I am currently use SQL 2000 and will move to SQL 2005 or 2008, and I am a SQL scripter and want to know such new things in details that are introduced with SQL Server 2005/2008.
Thank you in advance.

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2008-08-06 : 11:15:10
Too many to adequately cover I think. I doubt it would be useful to anyone to try and post them all here. Unless just maybe anecdotes about what new features are used the most / which we like the most now that we have them.

new features like pivot, rownumber, (MAX) datatypes.....

http://www.microsoft.com/sql/prodinfo/features/default.mspx is probably a good first step


-------------
Charlie
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2008-08-06 : 11:16:20
And of course the 2005 books on line

http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

-------------
Charlie
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-06 : 13:00:55
http://www.microsoft.com/sql/prodinfo/features/top30features.mspx
Go to Top of Page
   

- Advertisement -