简单的SQL文的问题

[hidejay]

原SQL文为： strSQL = "insert into HIS_BUGDETAIL(Bug_ID,Bug_Name,Bug_Check,Bug_SubSystem,Prg_Name,Prg_ID,Bug_Same," & _
"Bug_SubmitID,Bug_SubmitDate,Bug_Detail,Bug_Suggest,Bug_Priority,Bug_Deadline,Bug_Receive, " & _
"Bug_ReceiveDate,Bug_Type,Bug_Result,Bug_Object,Bug_Attach,Bug_Corrector,Bug_Confirm," & _
"Bug_CorrectorDate,Bug_ConfirmDate,Bug_Cause)" & _
" VALUES(@Bug_ID,@Bug_Name,@Bug_Check,@Bug_SubSystem,@Prg_Name,@Prg_ID,@Bug_Same," & _
"@Bug_SubmitID,@Bug_SubmitDate,@Bug_Detail,@Bug_Suggest,@Bug_Priority,@Bug_Deadline,@Bug_Receive, " & _
"@Bug_ReceiveDate,@Bug_Type,@Bug_Result,@Bug_Object,@Bug_Attach,@Bug_Corrector,@Bug_Confirm," & _
"@Bug_CorrectorDate,@Bug_ConfirmDate,@Bug_Cause)"

[hidejay]

这是取自一个名叫MS_BUGDETAIL的表，内容所有的键值都一样的，我想把MS_DETAIL中的内容全部添加到新的HIS_DETAIL数据库中，然后由于再次添加的时候，会有主键冲突，所以我想各位给我一段SQL文，能把除了HIS_DETAIL内以有的内容之外其他的内容直接添加在HIS_DETAIL表的后面，这是在VB。NET内，由按键实现的

[yizhixiaozhu]

看了半天你想干吗啊

[hidejay]

HIS_BUGDETAIL不是HIS_DETAIL

[yizhixiaozhu]

能把除了HIS_DETAIL内以有的内容之外其他的内容直接添加在HIS_DETAIL表的后面

这句我硬是没看懂

以外的数据从哪里来?

[hidejay]

就是原来添加过去的数据不动，后来添加过去的数据直接接在原数据的后面，用一个按钮实现，谢谢

[hidejay]

各位大侠帮忙啊~

[l3300]

SQL可实现：
insert into HIS_DETAIL
select * from MS_BUGDETAIL
where not exists (select * from HIS_DETAIL)