declare @strTableName Nvarchar(80),@n int,@str Nvarchar(4000)
set @strTableName=''
set @n=1
set @str=N'select @n=count(*) from '+ @strTableName//这样写法不对
exec sp_executesql @str,N'@N int output',@n output
select @n
set @strTableName=''
set @n=1
set @str=N'select @n=count(*) from '+ @strTableName//这样写法不对
exec sp_executesql @str,N'@N int output',@n output
select @n
set @strTableName='tbA'
set @n=1
set @ss='select @n=count(*) from '+ @strTableName
exec sp_executesql @ss ,N'@n int output',@n output
select @n
@n int,
@sql varchar(200)
set @strTableName='……'
set @sql = 'select count(*) from ' + @strTableName
set @n = exec(@sql)
你查一查exec的用法
set @strTableName=''--表名
set @strTableName='declare @n int set @n=1 select @n=count(*) from ' + @strTableName +' select @n'--//这样写法不对
execute(@strTableName)
@table_name varchar(255) ASexec('Delete From '+@table_name)
GO
@table_name varchar(255) ASexec('select From '+@table_name)
declare @strTableName varchar(80),@n int,@sql nvarchar(1000)
set @strTableName='sales'
set @n=1
set @sql='select @n=count(*) from '+ @strTableName
exec sp_executesql @sql ,N'@n int output',@n output
select @n
set @n=''
select @n='count(*) from '+@strTableName
set @n=''
select @n='count(*) from '+@strTableName