Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Which command removes all the rows from the table without logging individual row deletions ?
on 1/12/2012 | Category:
Sql Server Interview questions
| Views: 6267 |
Select from following answers:
Truncate will not log individual row deletion.
Here is an example of how we can count the rows before and after truncate
SELECT COUNT(*) AS BeforeTruncateCount FROM MyTable.MyJob;
TRUNCATE TABLE MyTable.MyJob;
SELECT COUNT(*) AS AfterTruncateCount FROM MyTable.MyJob;
Show Correct Answer
Many Interviews |
< Previous :
What is the clause that specifies a condition for ...
Next > :
What is the command that is used to set a set of p ...
Comments or Responses
Login to post response
More Interview Questions by Chvrsri
What is the command that is used to set a set of privileges that can b ...
What is the name given to a type of assembly which which contains loca ...
Which of the following are known to be the attributes of an Object ?
Generally Reference types are inherited from which class?
What is UDDI ?
What is the difference between Pre-Render and Render events in ASP pag ...
By default where the sessions ID's are stored ?
Which among the following is the common property in every Validation c ...
Latest Interview Questions
In Singleton Pattern, how will you make sure that threading is done wi ...
In Singleton Design Pattern, synchronization is essential ?
Static members are 'eagerly initialized' ?
Are Web services only written in .NET ?
Is it good to load jquery from CDN(Content delivery network) ?
A stored procedure must contains at least two parts: (1) stored proc ...
A stored procedure can be called from a trigger, another stored proced ...
Is it good to store connection strings in a separate text file for you ...