＋设为首页 ＋添加到收藏夹
表1
id name age
1 小张 22
2 小王 33
表2
id name age mark
现在的要求是从表1中把记录写入表2，所的记录为
id name age mark
1 小张 22 1小张22
2 小王 33 1小王33
关键就是最后一个字段的内容怎么得到，相当于字符串组合
insert 表2 select *,cast(id as varchar(10))+name+cast(age as varchar(10)) from 表1
insert into 表2 select *,cast(id as varchar(3))+name+cast(age as varchar(3)) from 表1
insert into 表2 select *,cast(getdate() as carchar(10))+cast(id as varchar(3))+name+cast(age as varchar(3)) from 表1
insert into 表2 select *,cast(year(getdate()) as varchar(4))+
cast(Month(getdate()) as varchar(2))+
cast(day(getdate()) as varchar(2)) +
cast(id as varchar(5))+
name+
cast(age as varchar(3)) from 表1
insert into 表2 select *,convert(char(8),getdate(),112)+cast(id as varchar(3))+name+cast(age as varchar(3)) from 表1
