what is the difference between Delete and Truncate
Answer Posted / manoj pandey
Check following blog post for Difference Delete vs Truncate: http://sqlwithmanoj.wordpress.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Using the customer, and order table in northwind database, please write a query to produce xml?
How do you manipulate data?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
what are defaults? : Sql server database administration
What is database replication? What are the different types of replication you can set up in sql server?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
Can you explain full-text query in sql server?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Explain what you mean by 3 tier architecture.
Do you know sql server 2008 introduces automatic auditing?
What are locks in sql?
What is table constraint?
Why do we use non clustered index?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration