请大家给我看一看,问题出在什么地方:declare @tblname varchar(100),@ckbhx char(2)
declare @sting varchar(100)declare @jlgs intset @ckbhx='01'set @tblname='ckb'+@ckbhxset @sting='select count(*) from '+@tblnameselect @jlgs=execute(@sting)
declare @sting varchar(100)declare @jlgs intset @ckbhx='01'set @tblname='ckb'+@ckbhxset @sting='select count(*) from '+@tblnameselect @jlgs=execute(@sting)
declare @sting nvarchar(100)
declare @jlgs int
set @ckbhx=N'01'
set @tblname=N'ckb'+@ckbhx
set @sting=N'select @jlgs=count(*) from '+@tblname
exec sp_executesql @sting,N'@jlgs int output',@jlgs output
select @jlgs--这样试试