1CREATE PROC myproc AS
2BEGIN
3 SELECT name FROM SYSOBJECTS
4END
5go
6
7DECLARE @t TABLE (name varchar(100))
8INSERT @t (name)
9exec myproc
1Declare @Phone nvarchar(30);
2Declare @Fax nvarchar(30);
3
4select @Phone = phone , @Fax = fax from customer where customerID = 1;