declare @tbl varchar(10), @sql Nvarchar(1000), @count intselect @tbl='tablename'
set @sql ='select @count=COUNT(*) from [' +@tbl+ ']'
exec sp_executesql @sql, N'@count int output',@count OUTPUT
select @count
执行之后@count = null,
请问,如何获得这个值。急!!
set @sql ='select @count=COUNT(*) from [' +@tbl+ ']'
exec sp_executesql @sql, N'@count int output',@count OUTPUT
select @count
执行之后@count = null,
请问,如何获得这个值。急!!
set @sql ='select @count=COUNT(*) from [' +@tbl+ ']'
exec sp_executesql @sql, N'@count int output',@count OUTPUT
select @count
set @sql ='select @count=COUNT(*) from [' +@tbl+ ']'
exec sp_executesql @sql, N'@count int output',@count output
select @count
set @sql ='select @count=COUNT(*) from [' +@tbl+ ']'
exec sp_executesql @sql, N'@count int output',@count output
select @count