动态sql语句输出参数

declare @sql nvarchar(2000) 
declare @cou int 
declare @id varchar(20) 
set @id='1' 
set @sql='select @count=count(*) from emp where id=@id' 
exec sp_executesql @sql, N'@count int out,@id varchar(20)', @cou out 
,@id 
print @cou 

@cou接收 @count传出的值

posted @ 2014-12-26 09:05  Tony二师弟  阅读(440)  评论(0编辑  收藏  举报