1. Vertabelo
  2. Вопросы
0
Отвечен

SQL Server Identity seed / increment arguments

Kindler Chase 10 лет назад • обновлен anonymous 7 лет назад • 6
With SQL Server, there are parameters for the Identity property allowing the seed and increment values to be set. Do we have access to the seed / increment arguments?
https://msdn.microsoft.com/en-us/library/ms186775.aspx

If not, may I suggest as an option?

Thanks!
На рассмотрении
Agnieszka Kozubek-Krycuń (Chief Scientist) 10 лет назад
+1
Agnieszka Kozubek-Krycuń (Chief Scientist) 10 лет назад
We'll soon add this feature. Thank you for pointing it out to us.
+1
Отвечен
Jarosław Błąd (CEO) 10 лет назад
It is done and on production.

Kindler Chase 10 лет назад
Found the option for identity seed/increments and it works great. Not sure if this is intended behavior, but I can set the increment increment without setting the identity seed; when I do that, the SQL generated strips the increment/seed (which makes sense without a seed). When this occurs, should there be an error on the table?
+1
Jarosław Błąd (CEO) 10 лет назад
You are right. Both parameters have to be set or neither. We will add validation check. Thanks for pointing this.

Сервис поддержки клиентов работает на платформе UserEcho