自己做个测试例子吧CREATE TABLE tb1(id int IDENTITY(1,1),col int) INSERT INTO tb1(col) VALUES(10) INSERT INTO tb1(col) VALUES(20)SELECT * FROM tb1------------CREATE TABLE tb2(id int ,col int) INSERT INTO tb2(col) VALUES(10) INSERT INTO tb2(col) VALUES(20)SELECT * FROM tb2
自动增长列 identity(起始值,步长)实例:--建表,很简单,就不说了 CREATE TABLE [Photos] ( [PhotoID] [int] IDENTITY (1, 1) NOT NULL , [AlbumID] [int] NOT NULL , [Caption] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , ) --清空表 truncate table dbo.Photos GO --打开容许对被IDENTITY修饰的列进行插入的开关,默认示关闭的,也就是不容许 set IDENTITY_INSERT dbo.Photos on insert into Photos(PhotoID,AlbumID,Caption)values(1,1,''maql1'') insert into Photos(PhotoID,AlbumID,Caption)values(1,2,''maql2'') insert into Photos(PhotoID,AlbumID,Caption)values(1,3,''maql3'') insert into Photos(PhotoID,AlbumID,Caption)values(2,1,''zhangr1'') insert into Photos(PhotoID,AlbumID,Caption)values(2,2,''zhangr2'') insert into Photos(PhotoID,AlbumID,Caption)values(2,3,''zhangr3'') go --关闭IDENTITY_INSERT开关,也就是不容许对这一列进行插入,而是让其自动增长 set IDENTITY_INSERT dbo.Photos off insert into Photos(AlbumID,Caption)values(1,''maql1'') insert into Photos(AlbumID,Caption)values(2,''maql2'') insert into Photos(AlbumID,Caption)values(3,''maql3'') insert into Photos(AlbumID,Caption)values(1,''zhangr1'') insert into Photos(AlbumID,Caption)values(2,''zhangr2'') insert into Photos(AlbumID,Caption)values(3,''zhangr3'') insert into Photos(AlbumID,Caption)values(3,''maql4'') go 文章出处:http://www.diybl.com/course/7_databases/sql/sqlServer/20071226/95392.html
INSERT INTO tb1(col) VALUES(10)
INSERT INTO tb1(col) VALUES(20)SELECT * FROM tb1------------CREATE TABLE tb2(id int ,col int)
INSERT INTO tb2(col) VALUES(10)
INSERT INTO tb2(col) VALUES(20)SELECT * FROM tb2
identity(起始值,步长)实例:--建表,很简单,就不说了
CREATE TABLE [Photos] (
[PhotoID] [int] IDENTITY (1, 1) NOT NULL ,
[AlbumID] [int] NOT NULL ,
[Caption] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
)
--清空表
truncate table dbo.Photos
GO
--打开容许对被IDENTITY修饰的列进行插入的开关,默认示关闭的,也就是不容许
set IDENTITY_INSERT dbo.Photos on
insert into Photos(PhotoID,AlbumID,Caption)values(1,1,''maql1'')
insert into Photos(PhotoID,AlbumID,Caption)values(1,2,''maql2'')
insert into Photos(PhotoID,AlbumID,Caption)values(1,3,''maql3'')
insert into Photos(PhotoID,AlbumID,Caption)values(2,1,''zhangr1'')
insert into Photos(PhotoID,AlbumID,Caption)values(2,2,''zhangr2'')
insert into Photos(PhotoID,AlbumID,Caption)values(2,3,''zhangr3'')
go
--关闭IDENTITY_INSERT开关,也就是不容许对这一列进行插入,而是让其自动增长
set IDENTITY_INSERT dbo.Photos off
insert into Photos(AlbumID,Caption)values(1,''maql1'')
insert into Photos(AlbumID,Caption)values(2,''maql2'')
insert into Photos(AlbumID,Caption)values(3,''maql3'')
insert into Photos(AlbumID,Caption)values(1,''zhangr1'')
insert into Photos(AlbumID,Caption)values(2,''zhangr2'')
insert into Photos(AlbumID,Caption)values(3,''zhangr3'')
insert into Photos(AlbumID,Caption)values(3,''maql4'')
go
文章出处:http://www.diybl.com/course/7_databases/sql/sqlServer/20071226/95392.html
这个
baidu一下