21 Mayıs 2014 Çarşamba

How to set start value for Auto Increment Column in MSSQL?

Sometimes, You need to set a start value for your auto increment columns. For example, It should start 0 value, or another ... How can you do this?
You can use DBCC (Database Console Command) and Following command will do it for you.


DBCC CHECKIDENT ('s_dimensionType', RESEED, 0)

Hiç yorum yok: