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

SQL Server Identity seed / increment arguments

Kindler Chase 7 лет назад • обновлен anonymous 4 года назад • 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) 7 лет назад
+1
Agnieszka Kozubek-Krycuń (Chief Scientist) 7 лет назад
We'll soon add this feature. Thank you for pointing it out to us.
+1
Отвечен
Jarosław Błąd (CEO) 7 лет назад
It is done and on production.

Kindler Chase 7 лет назад
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) 7 лет назад
You are right. Both parameters have to be set or neither. We will add validation check. Thanks for pointing this.

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