Understanding Sequences in Transact-SQL (SQL Study Material)

SQL Study Material (Good Documentation)
 
If you are a Database Developer or a Database Admin, you know for sure that knowing SQL comes handy when solving Business questions. The documentation website for T-SQL will explain various Aggregation Functions. The link  can be found here.
 
1. Understanding Sequences in Transact-SQL, just like Identity columns, when inserting into a table instead of calling NEXT_VALUE_FOR function every time when using Identity.

Question: Why would a developer use sequences instead of Identity columns?
Answer: For example, when the application needs to reserve 10 sequence numbers, requesting values from Identity Columns could result in skipping some values or duplicates. A developer can use sp_sequence_get_range to retrieve several numbers in the sequence at once.
 
- There are limitations to using sequences, unlike Identity Columns whose values cannot be changed, sequence values are not automatically protected after insertion into the table.
Technology published

Buy Me Coffee


Was this page helpful?

Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful..



© 2020 - ErnesTech - Privacy