Interested to Buy Any Domain ? << Click Here >> for more details...
wat new abt truncate in sql server
- 2 Answers
- 6726 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 |
diffrence between Cluster Index and non Cluster Index
Define inner join? Explain with an example?
How do I get to sql server configuration manager?
How to create a Master database in SQL server ?
How to write stored procedure to update the data in 10 tables
What function does a database engine serve in the sql server?
List the different types of collation sensitivities in sql server?
what are the types of indexes? : Sql server database administration
Which Model uses the SET concept
How do we get current date in SQL Server 2000, Oracle, MS Access?
Who is the owner of a schema in ms sql server?
What type of Index will get created after executing the above statement?
-
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)
