动态sql赋值问题
declare @rowcount int;
exec ('select count(['+@Colm+']) # from ['+@Table+']')
如何将count 的值赋给@rowcount
问题点数：50、回复次数：3Top
1 楼zlp321002（Life Is Good,Let's Shine）回复于 2006-03-16 12:14:42 得分 50
declare @rowcount int,
@sqls nvarchar(4000)
set @sqls='select @rowcount =count('+@Colm+') from ['+@Table+']'
exec sp_executesql @sqls,N'@rowcount int output',@rowcount output
select @rowcountTop
2 楼huailairen（流浪猫--很想养只猫，带着它到处流浪。）回复于 2006-03-16 12:14:56 得分 0
改成。
exec ('select '+@Colm+' from ['+@Table+']')
set @rowcount=@@rowcount
Top
3 楼sxycgxj（云中客）回复于 2006-03-16 12:50:56 得分 0
declare @rowcount int,
@sqls nvarchar(4000)
@Colm varchar(100)
set @colm=字段
set @sqls='select @rowcount =count('+@Colm+') from ['+@Table+']'
exec(@sqls)
select @rowcountTop
