Answers for "how to return multiple values from stored procedure in sql server"

how to return multiple values from stored procedure in sql server

CREATE PROC myproc AS 
BEGIN
     SELECT name FROM SYSOBJECTS
END
go

DECLARE @t TABLE (name varchar(100))
INSERT @t (name)
exec myproc

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;