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
How to insert a new row into a table with "insert into" statements in ms sql server?
Is there any difference between primary key and unique with the not null condition?
What types of replication are supported in sql server?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Can you explain full-text query in sql server?
Explain the dirty pages?
Can sub report data source be different from that of the parent report?
What happens if date-only values are provided as date and time literals?
what does the automatic recovery do? : Sql server administration
Explain index in sql server?
How to connect sql server management studio express to sql server 2005 express?
Why I am getting this error when dropping a database in ms sql server?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What do you mean by 'normalization'?
What are number line correlation administrators will use while working with a subquery?
