主题:SQL的存储过程中,表名是不是不可以是变量?
想做一个清空数据库的存储过程,总提示不对
CREATE PROCEDURE cleandb
@dbname VARCHAR(20)
AS
delete from @dbname
dbcc checkident ('@dbname', reseed, 1)
GO
提示:必须声明变量"@dbname"
CREATE PROCEDURE cleandb
@dbname VARCHAR(20)
AS
delete from @dbname
dbcc checkident ('@dbname', reseed, 1)
GO
提示:必须声明变量"@dbname"