34,590
社区成员
发帖
与我相关
我的任务
分享
create table test1 (a varchar(10),b varchar(10),c varchar(10),d int)
insert into test1
select 'Jack','s25301','男',19 union
select 'Tom','s25373','女',22
go
create table stuinfo
(
stuname varchar(4),
stuno varchar(6),
stusex varchar(4),
stuage int
)
insert stuinfo (stuname,stuno,stusex,stuage)
select 'Jack','s25301','男',19 union
select 'Tom','s25373','女',22
select * from stuinfo
/*
stuname stuno stusex stuage
------- ------ ------ -----------
Jack s25301 男 19
Tom s25373 女 22
(2 row(s) affected)
*/