笔记14 DBCC CHECKIDENT 的用法,主键自增列重新设置种子值

笔记14 DBCC CHECKIDENT 的用法,主键自增列重新设置种子值

 1 -- DBCC CHECKIDENT 的用法,主键自增列重新设置种子值
 2 USE [pratice]
 3 INSERT [dbo].[tabelcheckindent]
 4 SELECT 'n'
 5 GO 10
 6 
 7 SELECT * FROM [dbo].[tabelcheckindent]
 8 
 9 DELETE FROM [dbo].[tabelcheckindent]
10 
11 USE [pratice]
12 GO
13 DBCC CHECKIDENT ([tabelcheckindent], RESEED, 51)
14 GO

 

posted @ 2013-08-01 22:45 桦仔 阅读(...) 评论(...)  编辑 收藏