SQL ,Data Warehouse and Testing Concepts

Temporary table in SQL SERVER Temporary table: We create temporary table for temporary storing of data as the name suggests. It  is very...

Q. What is the difference between Local temporary table and Global temporary  table ? Local temporary table:   It is prefixed with # to ...

Q What are different types of constraint in SQL ?     Following are the different types of constraints in SQl:-     Primary Key Constrai...

Q How to delete duplicate records from a table ?        This is one of the famous question asked by  an interviewer. Lets us see how to to...