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 Table In Sql Server
Derived tables:- Derived tables are the tables which are created on the fly with the help of the Select statement.…
Pivot and Unpivot table in SQL SERVER
Pivot Table:- Pivot tables are used to summarize and display the data, specially in case of report data by means…