Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 21265 Views
- I also Faced
- E-Mail Answers
Answer Posted / saradhi
Truncate command result can be rolled back as it is not
made an entry in the log where as Delete command result
can't be rolled back
| Is This Answer Correct ? | 5 Yes | 47 No |
Post New Answer View All Answers
Can you explain what are various ways to enhance the ssrs report?
what are triggers? : Sql server database administration
How to change the password of a login name in ms sql server?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is msdb database? : SQL Server Architecture
How to select true false based on column value in sql server?
How to create user defined functions with parameters?
Do you know what is a linked server in sql server?
what are user defined datatypes and when you should go for them? : Sql server database administration
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
Does sql server 2000 clustering support load balancing?
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
Why main is user defined function?
Explain different types of collation sensitivity?
What is a data collection table?
