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
Write a sql query to get zero records from a table having n number of records?
What is an inner join?
What is autocommit mode in sql server?
How do I partition a table in sql server?
What are number line correlation administrators will use while working with a subquery?
Can we write trigger for view?
How to list all tables in the database using odbc_tables()?
What is a fan-out query in SQL Azure?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is scalar user-defined function?
What happens if strings are casted into wrong code pages in ms sql server?
What are rows and columns?
How can I change procedure name in sql server?
what are cursors? : Sql server database administration
Define tool Manage Statistics in SQL Server 2000 query ?