declare @tblName varchar(50)
select @tblName=dx_dbtable from #ls_dxtable where id=@id
set @tblName='tbo_'+@tblName--拼接要查找的表名 select @jtdxSumCount=Count(*) from @tblName where isEnd=0 and isdelete=0(这个语句里老是提示说@tblName为定义,为什么啊?)
select @tblName=dx_dbtable from #ls_dxtable where id=@id
set @tblName='tbo_'+@tblName--拼接要查找的表名 select @jtdxSumCount=Count(*) from @tblName where isEnd=0 and isdelete=0(这个语句里老是提示说@tblName为定义,为什么啊?)
set @sql = N'select @jtdxSumCount=Count(*) from ' + @tblName + N' where isEnd=0 and isdelete=0'
exec sp_executesql @sql, N'@jtdxSumCount int output', @jtdxSumCount output