数据库中 把A表中的a字段和b字段数据 复制到B表中的aa字段和bb字段
如何写语句呢???
数据库中 把A表中的a字段和b字段数据 复制到B表中的aa字段和bb字段?
答案:3 悬赏:40
解决时间 2022-01-01 12:04
- 提问者网友:年齡太小℡蘿莉
- 2021-12-31 17:23
最佳答案
- 二级知识专家网友:傲娇菇凉
- 2021-12-31 17:55
如果你存在ab表,那么需要用insert into,如果不存在b表,那么用select * into
DB Code(sqlserver2005)
if not exists (select * from sysobjects where name='tab1')
begin
create table tab1
(
id int primary key identity(1,1),
column1 varchar(20),
column2 varchar(20)
)
end
Go
if not exists (select * from tab1)
begin
declare @number int,@strNumber varchar(10)
set @number=1
while @number<=10
begin
set @strNumber=ltrim(str(@number))
insert into tab1 values ('column1-Data'+@strNumber,'column2-Data'+@strNumber)
set @number=@number+1
end
end
Go
select * from tab1
Go
if not exists(select * from sysobjects where name='tab2')
begin
select column1,column2 into tab2 from tab1
end
else
begin
insert into tab2 (column1,column2) select column1,column2 from tab1
end
DB Code(sqlserver2005)
if not exists (select * from sysobjects where name='tab1')
begin
create table tab1
(
id int primary key identity(1,1),
column1 varchar(20),
column2 varchar(20)
)
end
Go
if not exists (select * from tab1)
begin
declare @number int,@strNumber varchar(10)
set @number=1
while @number<=10
begin
set @strNumber=ltrim(str(@number))
insert into tab1 values ('column1-Data'+@strNumber,'column2-Data'+@strNumber)
set @number=@number+1
end
end
Go
select * from tab1
Go
if not exists(select * from sysobjects where name='tab2')
begin
select column1,column2 into tab2 from tab1
end
else
begin
insert into tab2 (column1,column2) select column1,column2 from tab1
end
全部回答
- 1楼网友:冷眼_看世界
- 2021-12-31 20:52
insert into b表(aa,bb) select a,b from a
- 2楼网友:偏爱自由
- 2021-12-31 19:20
update a set a.bb = b.aa from a,b where a.[关联字段] = b.[关联字段]
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯