---
title: "Why to use SQL Sequence and its drawbacks ?"  
description: "Why to use SQL Sequence and its drawbacks ?"  
author: "Anonymous User"  
published: 2011-02-01  
updated: 2020-09-17  
canonical: https://www.mindstick.com/interview/348/why-to-use-sql-sequence-and-its-drawbacks  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# Why to use SQL Sequence and its drawbacks ?

In SQL Sequences are used for creating sequence numbers without any overhead of locking but one drawback is that when any of transaction is rolled back the sequence number is lost.\

## Answers

### Answer by Anonymous User

In SQL Sequences are used for creating sequence numbers without any overhead of locking but one drawback is that when any of transaction is rolled back the sequence number is lost.\


---

Original Source: https://www.mindstick.com/interview/348/why-to-use-sql-sequence-and-its-drawbacks

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.