What is the difference between MINUS and LEFT JOIN in SQL Server?

This question seems to be very easy and you will start answering once you listen the question. But, be careful while answering very easy questions. Interviewer might test you by asking this kind of tricky questions. Don’t think that the questions were asked

Read More

What are Magic tables?

Magic Tables: Magic tables are the virtual tables provided by SQL Server to store the recently inserted, deleted and updated values. Basically there are two types of magic tables in SQL Server namely ‘INSERTED‘ and ‘DELETED‘. These are much useful while working with

Read More