数据库SQL Server2005设计与应用2
create table test_table1(
name varchar(20),
city varchar(20)
)
go
insert into test_table1(name,city) values('张三','北京')
insert into test_table1(name,city) values('李四','上海')
insert into test_table1(name,city) values('王明明','上海')
go
create table test_table2
(
name varchar(20),
sexchar(2),
ageint
)
go
insert into test_table2(name,sex,age) values('张三','男',22)
insert into test_table2(name,sex,age) values('李倩','女',34)
insert into test_table2(name,sex,age) values('王明明','男',19)
go
select * from test_table1
select * from test_table2
页:
[1]