Can you tell me the difference between DELETE & TRUNCATE
commands?
Answer Posted / afzal_aziz
http://weblogs.sqlteam.com/mladenp/archive/2007/10/03/SQL-
Server-Why-is-TRUNCATE-TABLE-a-DDL-and-not.aspx
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
SQL Server Architecture ?
What is clr ddl trigger?
What are a scheduled jobs?
What are date and time data types in ms sql server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
How to execute the cursor queries with "open" statements?
What are the types of sql server?
Describe the left outer join & right outer join. : sql server database administration
What security features are available for stored procedure?
Where sql server usernames and passwords are stored in a sql server?
Find columns used in stored procedure?
What does ss stand for sexually?
Explain about protocol layer present in SQL server?
What is wide table?