Greenway Health

www.greenwayhealth.com

Interview Question

SQL Developer Interview Carrollton, GA

What's the difference between TRUNCATE and DELETE

Answer

Interview Answer

1 Answer

1

one gets logged, the other doesn't so you have your performance hit. Need elevated permissions i.e. dbo for TRUNCATE

Interview Candidate on Mar 6, 2012

Add Answers or Comments

To comment on this, Sign In or Sign Up.