怎么把存储过程中的返回值放到数据库里？

[95000100]

declare @quantity int，@counter int
execute delete_emp @employee_no=18316,@counter=@quantity output
insert into on_sale (a) values(@counter)

以上的程序把@COUNTERY放到库里是空的，什么也没？

[klan]

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)

[95000100]

不是的，declare @quantity int，@counter int
execute delete_emp @employee_no=18316,@counter=@quantity output
这两句执行没错，我得到返回值＠counter,但是怎么把这个值写到on_sale表的a里面呢?我插入到表里后发现从存储过程返回的值是空的

[wzh1215]

declare @quantity int，@counter int
execute delete_emp 18316,@quantity output
set @counter=@quantity
insert into on_sale (a) values(@counter)

[ycdelphicsdn]

你试一下这个怎么样
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)