SQL ,Data Warehouse and Testing Concepts

Q How many columns can a view support ?        A view can support maximum of 1024 columns. Q What is the difference between Primary ...

Q. How to check duplicate records in a table using SQL Server ?         Suppose we have a table without a primary key. We want to find ...

1. ISNULL() :  Syntax: ISNULL ( check_expression , replacement_value ) It replaces the NULL value with replacement value. If the Che...

SQL- Scenario based questions Part 1.                                    Now the recruiters are setting a new trend by asking a scenario ...