declare @tablename varchar
set @tablename = 'student'
-- select * from @tablename -- 此句会出错
exec('select * from ' + @tablename) -- 动态sql
set @tablename = 'student'
-- select * from @tablename -- 此句会出错
exec('select * from ' + @tablename) -- 动态sql
下面的示例创建并执行一个简单的 SELECT 语句,其中包含名为 @level 的嵌入参数。execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl = @level',
N'@level tinyint',
@level = 35
下面的示例创建并执行一个简单的 SELECT 语句,其中包含名为 @level 的嵌入参数。execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl = @level',
N'@level tinyint',
@level = 35