create table friends
(
firstname char(20),
lastname char(20),
id int
)goinsert into friends(firstname ,lastname,id)values('jack','wilson',1)
go
...
(
firstname char(20),
lastname char(20),
id int
)goinsert into friends(firstname ,lastname,id)values('jack','wilson',1)
go
...
firstname ,lastname,idvalues('jack','wilson',1)
go字段列表要加括号insert into friends( firstname ,lastname,id )
values('jack','wilson',1)
go
gocreate table friends
(
firstname char(20),
lastname char(20),
id int
)goinsert into friends
(firstname ,lastname,id)values('jack','wilson',1)
goinsert into friends
values('michanel','jakcson',2)
goinsert into friends
values('michanel','tyson',3)
goinsert into friends
values('john','Hendery',5)
gocreate table students
(
stu_fname char(20),
stu_lname char(20),
id int
)
goinsert into students
select *
from friends
go
values('jack','wilson',1)
values(........)
字段列表要用括号括起来