Different types of ANSI standard joins

INNER JOIN (SIMPLE JOIN): This returns all rows for which there is at least one match in BOTH tables. This is...

What does UNION do or what result set UNION return ? What is the difference between UNION and UNION ALL?

UNION merges the contents of two structurally-compatible tables into a single combined table. This return unique records from all the...

What will be the result of the query below? Explain your answer?

select case when null = null then 'True' else 'False' end as ResultSet;

SPACE

USE CASE: When we are working on TSQL or some text based scripting we may need some extra space in between...

STUFF

Use case when we are working on TSQL or Query ,some time we came such a situation when we need...

Common uses of stored Procedure sp_MSforeachtable

We will get the brief idea about undocumented procedure sp_MSforeachtable of the Master database.

sp_MSforeachtable can be used to loop through all...

Generate list of all Month name

DECLARE @year INT
SET @year = 2016

;WITH months AS(
    SELECT 1 AS Mnth, DATENAME(MONTH, CAST(@year*100+1 AS VARCHAR) + '01')  AS monthname
    UNION ALL
 ...

Get each table space and their rows count

Sometime we need to know how much table space are used to store the data and also wish to know...

SQL Basics for Beginner

SQL BasicsAn instruction to a database to combine data from more than one table.A SQL join combines records from two or more...

SQL Create Table

SQL CREATE TABLEThe CREATE TABLE statement is used to create a table in a database to stored data.Tables are organized...