打掉了两个引号,再发一次。create proc a
as
begin
declare @name varchar(20)
select @name = 'buyproduct'
drop table @name
end
运行说@name有错误
as
begin
declare @name varchar(20)
select @name = 'buyproduct'
drop table @name
end
运行说@name有错误
as
begin
declare @name varchar(20)
select @name = 'buyproduct' --要加单引号
EXEC('drop table '+@name+'') --表名是变量,要使用动态SQL语句
end
变量.
要用動態執行哦
exec('')或sq_executesql()
就可以的了