Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24556 Views
- I also Faced
- E-Mail Answers
Answer Posted / sachin patil
Truncate is DDL Command while Delete is DML Command
| Is This Answer Correct ? | 26 Yes | 2 No |
Post New Answer View All Answers
What are the different types of upgrades that can be performed in sql server?
What is transaction server explicit transaction?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What are recommended options to be used while using db mirroring? : sql server database administration
What is the use of RDBMS?
Explain about protocol layer present in SQL server?
How optimize sql query with multiple joins in sql server?
What are the different methods available under sqlcommand class to access the data?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Why use “nolock” in sql server?
what are database files and filegroups? : Sql server database administration
Can you roll back the ddl statement in a trigger?
What are subqueries in sql server? Explain its properties.
Can a cursor be updated? If yes, how you can protect which columns are updated?
why would you call update statistics? : Sql server database administration
