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，級(jí)別 11，狀態(tài) 5，過(guò)程 C，第 5 行 無(wú)法對(duì) 表'#A' 執(zhí)行 刪除，因?yàn)樗淮嬖冢蛘吣鷽](méi)有所需的權(quán)限。
(68677 行受影響)
(0 行受影響)
(0 行受影響)
(1 行受影響)
這個(gè)存儲(chǔ)過(guò)程的錯(cuò)誤怎么改
慕工程0101907
2018-12-06 15:29:56
