a表和b表合并,结果留在a表,清空b表.

[cilyboy]

a表和b表合并,当然a,b表已经对比过一次了,不会重复,现在需要把b表的内容合并到a表中,b表清空掉.
求简单的存储过程.

[cilyboy]

a表和b表字段一样,合并后字段都不能改

[zlp321002]

insert into A表(字段....)
select 字段 ...from B表

truncate table B表

[子陌红尘]

--把b表的内容合并到a表中
insert into a select * from b

--清空b表
truncate table b

[zlp321002]

--存储过程

Create Proc SP_Test
as
begin
insert into A表(字段....)
select 字段 ...from B表

truncate table B表
End

[wgsasd311]

create proc p
as
if exists(select 1 from sysobjects where id=object_id('b') and xtype='u')
begin
insert into a select * from b
drop table b
end
go

[samson_www]

create procedure hebing
as
begin
insert into a select * from b
delete b
end

[-狙击手-]

create procedure hebing
as
begin
insert into a select * from b
truncate table b
end

[sunyong790903]

create procedure hebing
as
if exists(select 1 from sysobjects where id=object_id('b') and xtype='u')
begin
insert into a select * from b
trun table b
end

[sunyong790903]

create procedure hebing
as
if exists(select 1 from sysobjects where id=object_id('b') and xtype='u')
begin
insert into a select * from b
truncate table b
end

[cilyboy]

--存储过程

Create Proc SP_Test
as
begin
insert into A表(字段....)
select 字段 ...from B表

truncate table B表
End
-----------------
两个表都由一个id自增的字段
insert into taotao1(id,phone,name)

服务器: 消息 544，级别 16，状态 1，过程 SP_Test，行 4
当 IDENTITY_INSERT 设置为 OFF 时，不能向表 'taotao1' 中的标识列插入显式值。
这个咋整啊

[$扫地僧$]

你不要id就可以了啊!
try:
insert into taotao1(phone,name)

[$扫地僧$]

Create Proc SP_Test
as
begin
insert into A表 select phone,name from B表
truncate table B表
End

[数字化从业者老高]

标示列是不能通过程序进行插入数值的，你只需要插入其他的字段就行了。