While you know that a variable can be initialized to another variable in the declare statement.(You can refer this post http://beyondrelational.com/justlearned/posts/352/sql-server-variable-value-can-be-directly-assigned-to-another-variable-during-declaration.aspx), It is not possible to have them declared in a single declare statement like below
declare @v1 varchar(10)='test', @v2 varchar(10)=@v1
Published under: SQL Server Tips · · · ·
Makes complete sense..Thank-you for sharing!
Logical.. Thanks for sharing.