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
What is snapshot parameter in ssrs?
What is the difference between a view and a stored procedure?
How can you set the threshold at which sql server will generate keysets asynchronously?
What is user-defined inline table-valued function?
What is meant by indexing files?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What are the advantages of passing name-value pairs as parameters?
What is an execution plan? How would you view the execution plan?
What is primary key index?
What is attribute? : sql server analysis services, ssas
How to change parameter value inside the report?
Tell me what is the significance of null value and why should we avoid permitting null values?
What are the restrictions that views have to follow? : SQL Server Architecture
How to drop an existing stored procedure in ms sql server?
What is difference between count (*) and count column?
