wat new abt truncate in sql server
- 2 Answers
- 5566 Views
- HCL, HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / gk
Adding to the above answer truncate may or may not be
rolled back.
It can be rolled back if it is within a transaction.
| Is This Answer Correct ? | 4 Yes | 0 No |
Why main is user defined function?
difference between truncate, delete aur drop?
What is cte (common table expression)?
What is replication and database mirroring?
Explain Different types of Projects?
How do I run sql server 2014?
Explain multiserver query
Explain about temporary stored procedure?
Tell me what is de-normalization and what are some of the examples of it?
Explain error and transaction handling in sql server?
What are various limitations of the views?
What is key attribute?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
