Answer Posted / praful chavan
While using TRUNCATE stmt, WHERE clause can not be used.
When we use TRUNCATE stmt, Trigger does not get fire. After
using TRUNCATE stmt, all the deleted rows are not entered in
the transaction log file(.ldf)
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
How you can get a list of all the table constraints in a database?
How to link tables in sql server?
How much memory that we are using in Logshipping Concept?
What is an index in sql?
What is difference between clustered and non clustered index?
What are policy management terms?
How much space does sql server 2016 take?
What type of Index will get created after executing the above statement?
What is optimistic concurrency?
A trigger can reference objects outside the current database? State true or false.
What is a trace frag? Where do we use it?
what data regions are and what are the different data regions?
What is bcp? When does it use?
What are the basic functions for master, msdb, model, tempdb databases?
