Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
How do I reset an increment identity's starting value in SQL Server
code_junkie
Nov 10th, 2011
151
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
text
0.14 KB
| None
|
0
0
raw
download
clone
embed
print
report
DBCC CHECKIDENT('TableName', RESEED, 0)
DBCC CHECKIDENT (MyTable, RESEED, 0)
DBCC CHECKIDENT (MyTable, RESEED, 100)
TRUNCATE table
Add Comment
Please,
Sign In
to add comment
Public Pastes
Earn $$ on trading
CSS | 7 sec ago | 0.29 KB
Crypto Exchange Profits
12 min ago | 0.29 KB
Free money using older build [1.3]
24 min ago | 0.29 KB
Changelly Exploit
CSS | 36 min ago | 0.29 KB
X Brave Filter
40 min ago | 1.19 KB
✅ I earned $19000 with this method
49 min ago | 0.29 KB
Earn $$ on trading
CSS | 1 hour ago | 0.29 KB
S.S.S.S.S.S. - Super Special Sonic Server Sec...
1 hour ago | 0.18 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!