create procedure book_sel @Id varchar(10),@name varchar out
as
select @name = name from book where Id = @idgodeclare @name varchar(100)
declare @return_name varchar(100)execute book_sel '2',@return_name @name out
print @name
as
select @name = name from book where Id = @idgodeclare @name varchar(100)
declare @return_name varchar(100)execute book_sel '2',@return_name @name out
print @name
as
select @name = name from book where Id = @idgodeclare @name varchar(100)
declare @return_name varchar(100)execute book_sel '2',@return_name @name out
print @return_name
execute book_sel '2',@return_name out
print @return_name