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

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 ·  ·  ·  · 


Manas Ranjan Dash
39 · 5% · 1484
0
Liked
 
0
Asked



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
In what way an identity field differentiates the delete and truncate command? , 5.0 out of 5 based on 6 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]