create procedure C
as
if(exists(select name from tempdb..sysobjects where name like'%A%' and type='U'))
begin
drop table #A
end
SELECT * INTO #A FROM tbTriopticsRowDataHistory
delete from #A
where operator like '%10CM%' and matchtype<>'T'
delete from #A
where operator not like '%10CM%' and matchtype<>'M'
消息 3701，級別 11，狀態 5，過程 C，第 5 行 無法對 表'#A' 執行 刪除，因為它不存在，或者您沒有所需的權限。
(68677 行受影響)
(0 行受影響)
(0 行受影響)
(1 行受影響)
這個存儲過程的錯誤怎么改
慕工程0101907
2018-12-06 15:29:56
