Download
100% FREE
Office Document APIs for .NET
Online: 512
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
Which operation Resets Identity column in Table.
Posted by
vishalneeraj-24503
on 11/26/2013 | Category:
Sql Server Interview questions
| Views: 5064 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
Truncate
Drop
Delete
All Above
Truncate DDL command,when fired Resets Identity column in the Table.
Syntax is:
Truncate Table table_name;
Show Correct Answer
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
Which Select statement will not execute successful ...
Next > :
How to remove any table from DB in SQL-Server
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
How to remove any table from DB in SQL-Server
Which Gridview property must be enabled to work with pagination?
What is Gridview default Pagesize?
How to Break and Combine long Statements into multiple lines in Code-b ...
What do we mean by Optional parameter in VB.Net and Params in C#/Param ...
Can we write Insert or Update statement inside Row_Deleting event?
What is e.RowIndex and e.EditIndex in Gridview?
Which statement is False about Optional parameters in VB.Net?
Latest Interview Questions
How to delete a stored procedure named as MyProc from the SQL Server 2 ...
Assume we have one query to find out the count of products within each ...
If you use the BEGIN TRANSACTION statement, then execute 2 insert stat ...
Which of the following is FALSE regarding FOREIGN KEYS in SQL Server 2 ...
Which of the following is an example of a scalar subquery?
What is wrong with the T-SQL batch statement below: @find varchar(30 ...
A Customers table has columns names as firstname and lastname. Which o ...
Which of the following is FALSE regarding PRIMARY KEYS in SQL Server 2 ...
More ...
Show Correct Answer