Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 23386 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
What do you understand by check constraint in sql server?
What is the difference between a stored procedure and a user defined function?
Where in ms sql server is ’100’ equal to ‘0’?
Which are the new data types introduced in sql server 2008?
explain different types of joins? : Sql server database administration
What is identity?
Explain the purpose of indexes?
What is hot add cpu in sql server 2008?
Explain cross join or cartesian product in sql?
Difference between report and query parameter.
Explain what is use of dbcc commands?
What is inline variable assignment?
What is openxml in sql server?
What is sql server used for?
What are the differences between ms sql server & oracle?
