sql设置标识列

1. 如何利用sql语句设置标识列

use 数据库名称create table stu(id int primary key identity(1,1),age int ,[image] varchar(50)-----这个地方存图片名字就行了)检举

2. sql2012怎么设置标识列 自增

createtablestudent
(
s_nointidentity,--自增列
s_namevarchar(20),
mobilevarchar(20),
classvarchar(20)
)
insertintostudent(s_name,mobile,class)values('a','123','一年1班');
insertintostudent(s_name,mobile,class)values('b','1234','一年2班');
insertintostudent(s_name,mobile,class)values('c','1235','一年3班');
insertintostudent(s_name,mobile,class)values('d','1231','一年4班');
insertintostudent(s_name,mobile,class)values('e','1232','一年5班');