Interested to Buy Any Domain ? << Click Here >> for more details...
wat new abt truncate in sql server
- 2 Answers
- 6708 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 different types of backups avaialabe in sql server 2005?
Is candidate a key?
What is a view and what are its advantages?
Why the trigger fires multiple times in single login?
What is default constraint?
How would you Update the rows which are divisible by 10, given a set of numbers in column?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
what is extended StoreProcedure ?
How can I create a report based on a query? : sql server management studio
What is field in algebra?
What is blocking and how would you troubleshoot it? : sql server database administration
what is the main difference between constraints(like primary key etc..)& joins?
-
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)
