Venn-Diagrams for Joins in Sql Server

Venn-Diagrams for Joins :

How many Columns Table Stored in Sql Server

In Sql Server, Table can contains 1024 Columns.

What are the DDL Commands in Sql Server

DDL stands for Data Defination Language.

1. Create
2. Alter
3. Drop
4. Truncate

Write a query to retrieving all rows from the table in Sql Server

Select * from TableName

What are the Set Operators in Sql Server

There are Four Set Operators in Sql Server. Those are

1. Union
2. UnionAll
3. Intersect
4. exept

What are the DML Commands in Sql Server

DML Stands for Data Manipulation Language.

1. Insert
2. Update
3. Delete

which join can be used In Union using Sql Server

Ans) Outer Join