Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8526 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / rajiv singh
Truncate deletes all rows from table. But Delete deletes
row/rows by condition.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what are the different ways to return the rowcount of a table?
What are “phantom rows”?
When would you use the stored procedures or functions?
what are the different stages of Report Processing?
What is the difference between getdate and sysdatetime?
What is BCNF? How is it better than 2NF & 3NF?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
How many full-text indexes can a table have?
What is the difference between executequery () and executeupdate ()?
What is the difference between count and distinct count?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
How to send a ssrs report from ssis?
How much is a sql server license?
What is normalization and its types?
What part does database design plays a role in performance of an sql server-based application?
