Set two variables to receive SELECT results 1

[chicdog]

Is it possible to set two variables to receive the result of a Select statement knowing that there will be ONLY one row returning.

SET @Var1, @Var2 = (Select A,B From tblTable Where
Key=3)

Thanks,
Bryan

 

[jby1]

Select @Var1=A, @Var2=B From tblTable Where 
           Key=3

You will need to declare @Var1 and @Var2 before doing this.

 

[chicdog]

Thank you for the help.
Bryan