22,209
社区成员
发帖
与我相关
我的任务
分享
create table test(id int)
go
insert into test values(1),(2),(3),(4),(5)
go
insert into test select * from test
go
print '直接查询'
select COUNT(*) as result from test
go
declare @tablename nvarchar(50) = 'test'--传参过来的表名
declare @rowcount int,@sql nvarchar(50)
set @sql=N'select @count = count(ID) from '+@tablename
exec sp_executesql @sql,N'@count int out',@rowcount out
print '动态表名的结果'
select @rowcount as result
go
drop table test
go
直接查询
result
-----------
10
动态表名的结果
result
-----------
10