ASP.NET and SQL SERVER Tricks
Tuesday, May 24, 2011
How to set identity seed in SQL SERVER by QUERY
If u want next number is 5000
then set seed as:
DBCC CHECKIDENT (tablename, reseed, 4999)
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment