DELETE vs TRUNCATE Check: http://sqlwithmanoj.wordpress.com/2009/02/22/dif

Differencr Between DELETE and TRUNCATE?

Question Posted / manoj pandey

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

Please Help Members By Posting Answers For Below Questions

Write a sql query to get zero records from a table having n number of records?

1235

What is an inner join?

1040

What is autocommit mode in sql server?

1266

How do I partition a table in sql server?

1099

What are number line correlation administrators will use while working with a subquery?

1217

Can we write trigger for view?

1071

How to list all tables in the database using odbc_tables()?

1118

What is a fan-out query in SQL Azure?

123

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?

1066

What is scalar user-defined function?

1189

What happens if strings are casted into wrong code pages in ms sql server?

1167

What are rows and columns?

1065

How can I change procedure name in sql server?

1113

what are cursors? : Sql server database administration

1104

Define tool Manage Statistics in SQL Server 2000 query ?

1167