Jane's Technical Stuff
Archives
May 2002March 2003
May 2003
July 2003
August 2003
June 2005
July 2005
August 2005
December 2005
January 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
July 2008
August 2008
September 2008
October 2008
Monday, January 15, 2007
MSDN Virtual Lab: Express: What’s New in SQL Server 2005
I decided to take a look at the MSDN Virtual Labs after finding this a good way to work on my ASP.NET course. I figured I'd start off with the Express: What’s New in SQL Server 2005 lab and see how I got on. This was a 30 minute lab, and I've got quite a bit out of it.
I hadn't read anything about the new PIVOT and UNPIVOT functionality, and by following up on that I discovered about the introduction of Common Table Expressions which look like a much more elegant way of temporarily storing data for use within stored procedures etc. This should give a lot more flexibility.
The other thing I knew about but hadn't seen examples of was the TRY...CATCH functionality. This is a great addition, but it is a shame that it doesn't work with user defined functions as well.
I hadn't read anything about the new PIVOT and UNPIVOT functionality, and by following up on that I discovered about the introduction of Common Table Expressions which look like a much more elegant way of temporarily storing data for use within stored procedures etc. This should give a lot more flexibility.
The other thing I knew about but hadn't seen examples of was the TRY...CATCH functionality. This is a great addition, but it is a shame that it doesn't work with user defined functions as well.
Labels: Development, SQLServer2005
// posted by Jane @ 12:25 PM 
Comments:
