Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between Delete and Truncate
- 4 Answers
- 8701 Views
- CarrizalSoft Technologies, Geo Research Centre, I also Faced
- E-Mail Answers
Answer Posted / manoj pandey
Check following blog post for Difference Delete vs Truncate: http://sqlwithmanoj.wordpress.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what stored procedure can you use to display the current processes? : Sql server administration
Why do we use non clustered index?
What do you understand by a view?
What is the synonym of join?
Which is the latest version of sql server and when it is released?
How do I partition a table in sql server?
application server is slow what may be the problem
What is normalization? Explain its different types?
How to get the definition of a trigger back?
What is multi-statement table-value user-defined function?
What is sub-query in sql server? Explain its properties.
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is the difference between online clustering and Offline clustering?
What is the purpose of indexing?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
