读书人

下面这句SQL能不能优化一下,该如何解决

发布时间: 2012-03-16 16:34:56 作者: rapoo

下面这句SQL能不能优化一下
delete Forum_Vote where VoteID in (select VoteID from Forum_Vote where Topic_ID= '+@Topic_ID+ ' and VoteID not in( '+@VoteIDs+ '))

[解决办法]
delete Forum_Vote
where exists
(select 1 from Forum_Vote
where Topic_ID= '+@Topic_ID+ '
and VoteID not in( '+@VoteIDs+ ') and VoteID=Forum_Vote.VoteID)
[解决办法]
用可能效率好些

Delete A From Forum_Vote A
Inner Join
(select VoteID from Forum_Vote where Topic_ID= '+@Topic_ID+ ' and VoteID not in( '+@VoteIDs+ ')) B
On A.VoteID = B.VoteID

读书人网 >SQL Server

热点推荐