我试图在Microsoft sql Server上运行这套sql命令,但是我收到这个错误:
Msg 137,Level 15,State 1,Line 1
Must declare the scalar variable “@dbstatus”.
我以为我已经声明了变量,所以我不知道为什么它仍然抛出错误?
DECLARE @dbname nvarchar(100) DECLARE @dbstatus varchar(500) DECLARE @sqlCommand NVARCHAR(1000) create table #temptable (dbname nvarchar(100),status varchar(500)) DECLARE c1 CURSOR READ_ONLY FOR SELECT '[' + name + ']' FROM sys.databases WHERE name = 'EDDS1084543' OPEN c1 FETCH NEXT FROM c1 INTO @dbname WHILE @@FETCH_STATUS = 0 BEGIN SET @sqlCommand = 'SET @dbstatus = (SELECT Status FROM ' + @dbname + '.[EDDSDBO].[dtSearchIndex])' EXECUTE sp_executesql @sqlCommand INSERT INTO #tempTable(dbname,[status])VALUES (@dbname,@dbstatus) FETCH NEXT FROM c1 INTO @dbname END CLOSE c1 DEALLOCATE c1