临时表插入重复键？

CREATE PROCEDURE [dbo].[SummDesktop]

@MemberId int

AS

set nocount on

begin transaction

begin

Create table #TempSumm(id INT PRIMARY KEY,Title varchar(100),SysDate Datetime,SummUser varchar(50))

insert into #TempSumm select a.id,a.title,b.sysdate,(select users_truename from User_Member where id=b.Member_id) as SummUser

from Summarize a,SummarizeComment b

where a.id=b.Summ_id and a.Member_id=@MemberId

and not exists(select id from #TempSumm where id=a.id)

select id,Title,SysDate,SummUser from #TempSumm order by sysDate desc

end

commit transaction

GO

上面的not exists(select id from #TempSumm where id=a.id)这一句为了让临时表中不存在相同ID的记录，可是没有起作用啊，临时表中还是有重复的ID值Mssq临时表，该怎么写啊

（编辑：南平站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!