I loved this feature. I have always wanted this feature to be present in SQL Server. Last time when I met developers from Microsoft SQL Server, I had talked about this feature. I think this feature saves some time but make the code more readable.
---- SQL Server 2005 Way
DECLARE @MyVar INT
SET @MyVar = 5
SELECT @MyVar AS TestVar
GO
---- SQL Server 2008 Way
DECLARE @MyVar INT = 5
SELECT @MyVar AS TestVar
GO
Reference : Pinal Dave (http://www.SQLAuthority.com)
pinaldave
This will be a wonderful feature to have
now when we will upgrade to SQL 2008… that’s another story
It is a nice feature of sqlserver2008
thanks..