1.6w+
社区成员
- 全部
- VBS
- .NET技术
- VBA
- VB网络编程
- VB多媒体
- VB数据库
- VB控件
- VB COM/DCOM
- VB基础类
- VB API
- 问答
简单的SQL文的问题
原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)"
"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)"
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
l3300 2005-02-22
SQL可实现：
insert into HIS_DETAIL
select * from MS_BUGDETAIL
where not exists (select * from HIS_DETAIL)
insert into HIS_DETAIL
select * from MS_BUGDETAIL
where not exists (select * from HIS_DETAIL)
hidejay 2005-02-22
各位大侠帮忙啊~
hidejay 2005-02-22
就是原来添加过去的数据不动，后来添加过去的数据直接接在原数据的后面，用一个按钮实现，谢谢
yizhixiaozhu 2005-02-22
能把除了HIS_DETAIL内以有的内容之外其他的内容直接添加在HIS_DETAIL表的后面
这句我硬是没看懂
以外的数据从哪里来?
这句我硬是没看懂
以外的数据从哪里来?
hidejay 2005-02-22
HIS_BUGDETAIL不是HIS_DETAIL
yizhixiaozhu 2005-02-22
看了半天你想干吗啊
hidejay 2005-02-22
这是取自一个名叫MS_BUGDETAIL的表，内容所有的键值都一样的，我想把MS_DETAIL中的内容全部添加到新的HIS_DETAIL数据库中，然后由于再次添加的时候，会有主键冲突，所以我想各位给我一段SQL文，能把除了HIS_DETAIL内以有的内容之外其他的内容直接添加在HIS_DETAIL表的后面，这是在VB。NET内，由按键实现的
