Questions

  1. What is the difference between TRUNCATE and DELETE?
  2. Which TRUNCATE or DELETE is better?
  3. How to record actions happening on Stored Procedures?
  4. How to record actions happening on Functions?
  5. What is the difference between table variable, local temp table, global temp table and real table in SQL Server?
  6. How to combine values having same ID?
  7. What is the difference between GROUP BY and DISTINCT?

Be the first to comment

Leave a Reply

Your email address will not be published.


*