Interested to Buy Any Domain ? << Click Here >> for more details...
wat new abt truncate in sql server
- 2 Answers
- 6664 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 |
What are the disadvantages of indexes?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is plan freezing?
What is the syntax for encrypting a column in SQL Server?
How do you know which index a table is using?
What are acid properties of transaction?
How to rebuild master databse?
What are sp_configure commands and set commands?
What is equi join with example?
What is the difference between 2-Tier architecture and 3-Tier architecture
15 Answers CTS, MCN Solutions, Oracle,
What is sql server english query?
How ssrs maintain security?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
