What is difference between TRUNCATE and DELETE statement
Answer Posted / hari
Delete - is logged operation,so deletion of each row get
logged into the transcation log.
Truncate - won't logged
Delete - use where condition
Truncate - Can't use where condition
delete - fire the trigger
Trunacte - can't fire the triggger
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can you start sql server in different modes?
Write a SQL command to insert and update only a particular field?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is save transaction and save point?
What are the advantages of user defined function?
How many categories of data types used by sql server?
What is ems sql management studio? : sql server management studio
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?
Can we call stored procedure in view in sql server?
what stored procedure would you use to view lock information? : Sql server administration
Is it true, that there is no difference between a rule and a check constraint?
Explain difference between cross join and full outer join?
Tell me the difference between clustered and non-clustered index?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation