sqlserver 自动编号的字段 用sql脚本如何写

[jzinfo]

table1(ID,field1,field2,field3...)，假设ID是主键，自动编号的
create table table1 (
//ID这个字段如何写??
field1 char (10) not null,
field2 char (5) not null,
field3 char (50)
)
go

[百年树人]

table1(ID,field1,field2,field3...)
create table table1 ( 
  ID int identity(1,1),
  field1 char (10) not null, 
  field2 char (5) not null, 
  field3 char (50) 
) 
go

[htl258_Tony]

create table table1 ( 
  ID INT IDENTITY,
  field1 char (10) not null, 
  field2 char (5) not null, 
  field3 char (50) 
) 
go

[jia_guijun]

create table tb(
  ID int identity(1,1) not null,
)

========================================
http://www.dbtuning.cn
主营：中小企业数据库管理、优化、调校服务
========================================

[htl258_Tony]

要开始练习发贴的速度了.

[ks_reny]

[Quote=引用 1 楼 josy 的回复:]
SQL codetable1(ID,field1,field2,field3...)
create table table1 (
ID int identity(1,1),
field1 char (10) not null,
field2 char (5) not null,
field3 char (50)
)
go
[/Quote]
正解.