how to return multiple select from stored procedure in sql server code example
Example: stored procedure sql get multiple variable selects
Declare @Phone nvarchar(30);
Declare @Fax nvarchar(30);
select @Phone = phone , @Fax = fax from customer where customerID = 1;