حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

How to reset Auto Increment Identity column in SQL Server

abhinav

abhinav

SOLVED CLOSED ACTIVE ANSWERED
User: abhinav
Posted: on Jun 07, 2013 01:35 AM
Forum: SQL Server
Answer: 1
Views: 3557

Hello,

I have primary key in table like

1

2

3

it is auto increment. but now i want that next primary key value should start from 1001.

then what will be the query for it?

Thanks

Download FREE API for Word, Excel and PDF in ASP.Net

ashusingh

ashusing...

0 4

Reply
ANSWER
User: ashusingh
Replied: on Jun 07, 2013 03:16 AM
Modified: on Jun 07, 2013 04:29 AM
Report

Try this..

Declare @newValue int
set @newValue = 1000
DBCC CHECKIDENT ('Table_Name', reseed, @newValue)

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.