Answer Posted / manoj pandey
DELETE vs TRUNCATE
Check: http://sqlwithmanoj.wordpress.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/
~Manoj
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In which sql server version report builder introduced?
How to include date and time values in sql statements?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Does an index slow down updates on indexed columns?
What is the difference between index seek vs. Index scan?
How do clustered indexes store data?
What Are the Main Features of SQL Azure?
What are the differences between stored procedure and view in sql server?
How to grant a permission in ms sql server using "grant execute" statements?
When multiple after triggers are attached to sql table, how to control the order of execution?
How do you migrate data from mssql server to azure?
What are exact numeric data types in ms sql server?
What is an sql server agent?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is the correct order of the logical query processing phases?
