Interview Questions - In what way an identity field differentiates the delete and truncate command?

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


	Interview Questions

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


	Submit a Question


	Subscribe..

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

In what way an identity field differentiates the delete and truncate command?

Apr 25 2012 12:00AM by Manas Ranjan Dash

Question

In what way an identity field differentiates the delete and truncate command?

Answer

MSDN says With TRUNCATE, If the table contains an identity column, the counter for that column is reset to the seed value defined for the column. If no seed was defined, the default value 1 is used. To retain the identity counter, use DELETE instead.

Read More.. [66 clicks]

Published under: SQL Server Interview Questions · · · ·

Previous: How to change the length of a column defined with a Primary key constraint?
Next: Why can't a sparse column be eligible for Primary key?

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


	Submit

Your Comment

Sign Up or Login to post a comment.

"In what way an identity field differentiates the delete and truncate command?" rated 5 out of 5 by 6 readers +Manas Ranjan Dash

In what way an identity field differentiates the delete and truncate command?

Question

Answer

Your Comment