发布网友
共1个回答
热心网友
用EXEC执行字符串的形式就可以!
如下:
DECLARE @databaseName NVARCHAR(20)
DECLARE @deviceName NVARCHAR(30)
DECLARE @SQL NVARCHAR(1000)
SET @databaseName = 'table'
SET @deviceName = @databaseName + '_device'
SET @SQL='ALTER DATABASE ' + @databaseName + ' SET SINGLE_USER WITH ROLLBACK IMMEDIATE'
EXEC ( @SQL)
SET @SQL='RESTORE database ' + @databaseName + ‘ FROM @deviceName WITH RECOVERY’
EXEC ( @SQL)追问多谢