Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain about SQLOS?
If no size is defined while creating the database, what size will the database have?
What are the five characteristics of good data?
How to throw custom exception in Stored Procedure?
What is the default fill factor value?
What is dknf in normalization form?
What is collation?
Data table as parameter in sql server?
How to convert numeric expression data types using the cast() function?
Create and insert into temp table in sql server?
What is the default port for SQL Server over a firewall?
What is dirty page?
What is policy management?
How to view the error log for any specific instance? : sql server database administration
What are different types of views?
