Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24477 Views
- I also Faced
- E-Mail Answers
Answer Posted / amita
Delete command only delete the rows from the table but the
schema of the table yet remains.Whereas Truncate command
delete the rows along with the tale's schema from the
memory permanently.
| Is This Answer Correct ? | 3 Yes | 28 No |
Post New Answer View All Answers
Explain can you implement data mining in ssrs?
Explain candidate key, alternate key, and composite key?
Differentiate between truncate vs delete in mssql?
Which joins are sql server default?
What is difference between materialized view and view?
what are user defined datatypes? : Sql server database administration
What is the purpose of self join?
What is the difference between substr and charindex in the sql server?
Where can you find the error log information? : sql server database administration
How to insert a new row into a table with "insert into" statements in ms sql server?
What is a db view?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is the purpose of update statistics and scope_identity() function?
Name few of the dcl commands in sql?
What are the two modes of authentication in sql server?
