table1(ID,field1,field2,field3...),假设ID是主键,自动编号的
create table table1 (
//ID这个字段如何写??
field1 char (10) not null,
field2 char (5) not null,
field3 char (50)
)
go
create table table1 (
//ID这个字段如何写??
field1 char (10) not null,
field2 char (5) not null,
field3 char (50)
)
go
create table table1 (
ID int identity(1,1),
field1 char (10) not null,
field2 char (5) not null,
field3 char (50)
)
go
ID INT IDENTITY,
field1 char (10) not null,
field2 char (5) not null,
field3 char (50)
)
go
ID int identity(1,1) not null,
)========================================
http://www.dbtuning.cn
主营:中小企业数据库管理、优化、调校服务
========================================