Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22993 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / xyz
truncate basically clears the data from the rows of a
specified colomn.
e.g. truncate colomn_name from table_name
then this will only empty the colomn
delete is used to simpy delete anything from the table.
e.g. delete table_name
this will remove the whole table from the database.
| Is This Answer Correct ? | 9 Yes | 28 No |
Post New Answer View All Answers
How to select all columns of all rows from a table with a select statement in ms sql server?
What is the difference between lock, block and deadlock? : sql server database administration
Tell me what is sql profiler?
How to loop through returning rows?
How can we improve performance by using SQL Server profiler?
What is the difference function and stored procedure?
What is normalization and its types?
How to manipulate data from one table to another table ?
SQL Server Architecture ?
What is the default fill factor value?
What is view in sql?
How to find out the list schema name and table name for the database?
Explain about extended stored procedure?
where the connection string store in the database
what's the difference between a primary key and a unique key? : Sql server database administration
