Interested to Buy Any Domain ? << Click Here >> for more details...
wat new abt truncate in sql server
- 2 Answers
- 6851 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 binary string data types in ms sql server?
Can you explain what is the use of custom fields in report?
What is difference between drop truncate and delete?
What are the difference between data length and length in SQL Server-2008?
What do you understand by mirroring and mention the advantages of the mirroring?
How to find tables without indexes?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
How to use “drop” keyword in sql server and give an example?
How can we Use Linked Server? Uses of Linked server
What is master database? : SQL Server Architecture
What is SQL Profiler and the use of it?
What happens if an integer is too big for int date type?
-
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)
