SALIM ALI (12/19/2014)
the answer is only correct when using SqlServer 2012 and above. Previous versions prompt an error.
That`s not correct, as SQL 2k8 will work fine with the in-line assignement.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant