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
After removing a table from database, what other related objects have to be dropped explicitly?
Explain rdbms?
Why can there be only one clustered index and not more than one?
What are the restrictions applicable while creating views? : SQL Server Architecture
What is a livelock?
What is 3nf normalization?
what is an extended stored procedure? : Sql server database administration
How do you trace the traffic hitting a sql server?
What is sub query and its properties?
What is a cache in ssrs?
What is sql injection and why is it a problem? : sql server security
What are the steps to insert a table?
How to declare and use cursor variables?
What is the use of tempdb? What values does it hold?
Explain full-text query in sql server?
