创建一个表
create table demoTb
( ID int identity(1,1) primary key,
name varchar(30)
) |
查看有没有自增列 有就返回YES
IF ((SELECT OBJECTPROPERTY( OBJECT_ID(N'demoTb'), 'TableHasIdentity')) = 1)
PRINT 'Yes'
ELSE PRINT 'No'
|
如果想插入自增列的值就
declare @tableName varchar(250)
declare @sql nvarchar(1000)
select @tableName = 'demoTb'
select @sql ='SET IDENTITY_INSERT '+@tableName+' ON' +char(13)+'insert into demoTb(id,name) values(2,''wu'')'
print @sqlexec sp_executesql @sql
insert into demoTb(id,name) values(1,'wu')
select * from demoTb
|
本文转自lpxxn博客园博客，原文链接：http://www.cnblogs.com/li-peng/archive/2013/01/11/2855883.html，如需转载请自行联系原作者