Merge Command In Sql Server

Merge Command:- Merge command is a new feature introduced in the SQL Server 2008. It can perform Update, Insert and […]

Adding , Deleting and Updating a Column in a table

Many times we need to alter the table definition by adding , deleting or updating a column in the table.

Derived tables:- Derived tables are the tables which are created on the fly with the help of the Select statement. It

Pivot Table:- Pivot tables are used to summarize and display the data, specially in case of report data by means