Interview Questions - Which command is used to re-seed the identity value?

Getting Started with Adobe After Effects - Part 6: Motion Blur

This module helps you to share, discuss and learn interview questions and answers of different technologies

Home · Most Liked · Most Asked · Most Discussed · Sections

Which command is used to re-seed the identity value?

Mar 28 2012 12:00AM by Manas Ranjan Dash

Which command is used to re-seed the identity value?

DBCC CHECKIDENT can be used to manually set a new current identity value for the identity column.

DBCC CHECKIDENT ("Sales.ProductType", RESEED, 10);

Read More.. [50 clicks]

Previous: SQL Server - Is it possible to create index on more than one column?
Next: SQL Server - Is it possible to call a trigger from another trigger?

Manas Ranjan Dash

39 · 5% · 1482

Liked

Asked


Post this to my facebook wall
Tweet this
Like this
I have asked or faced this question during an interview

Your Comment

Sign Up or Login to post a comment.