stored procedure sql get multiple variable selects
snippet in sql

stored procedure sql get multiple variable selects

user8525

Declare @Phone nvarchar(30); 
Declare @Fax nvarchar(30); 

select @Phone = phone , @Fax = fax from customer where customerID = 1;