I am doing a talk next week at TechED Developers in Barcelona about new TSQL enhancements for developers. The session is:
DAT313 T-SQL Enhancements in SQL Server 2008 : Getting Down and Dirty. it is Wednesday at 1:30 in room 115.
The goal of this talk is to show you some cool new stuff in TSQL but also to show C# and VB developers that TSQL is not all that bad. I get the impression that developers hate TSQL. :)
So the TSQL designers decided to add a few “delighters” to the syntax to make C# and VB developers feel more at home.
The first is variable assignment at declaration time. For example:
DECLARE @MSFT char(4) = 'MSFT'
Print 'Using: ' + @MSFT
The next is using shortcut syntax like += or –+, etc:
SET Qty += 10
The addition of Table Value Parameters (TVPs) allows you to pass in datasets via ADO.NET in C#/VB as a parameter to a stored procedure, etc, will really make C# developers life easier (demo soon on the blog). Also cool integration with Google Maps or Virtual Earth and the geospacial data types will make developing apps with location much easier.
There are lots of other cool new features in there for developers, I will post some more on the blog soon.