try this:declare @quantity int,@counter int
declare @strSQL varchar(200)
execute delete_emp @employee_no=18316,@counter=@quantity output
set @strSQL='insert into on_sale (a) values(' + convert(varchar(10),@counter)+')'
exec(@strSQL)
declare @strSQL varchar(200)
execute delete_emp @employee_no=18316,@counter=@quantity output
set @strSQL='insert into on_sale (a) values(' + convert(varchar(10),@counter)+')'
exec(@strSQL)
execute delete_emp @employee_no=18316,@counter=@quantity output
这两句执行没错,我得到返回值@counter,但是怎么把这个值写到on_sale表的a里面呢?我插入到表里后发现从存储过程返回的值是空的
execute delete_emp 18316,@quantity output
set @counter=@quantity
insert into on_sale (a) values(@counter)
declare @quantity int,@counter int,@employee_no int
set @employee_no=18361
execute delete_emp @employee_no,@quantity output
set @counter=@quantity
insert into on_sale (a) values(@counter)