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. It is...

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...

SQL Server- Output clause

Output Clause:- The SQL SERVER 2005 gives us an Output Clause which gives us the information about each row affected by the...

CTE command In Sql Server

Common table expression (CTE):- Common table expression or CTE can be described as the temporary, named record set return by...

SQL Server-Table Variable

Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar way as we...

SQL Server - Local temporary table

Local temporary table:- Local temporary table is created in the tempdb and it is visible to the current user's session...

SQL Server - Global temporary tables

Global temporary table:- Global temporary table is created in the tempdb  and it is visible to all other sessions as well. Global...

How to remane a Table in Sql Server

To rename a column in a SQL Table following command can be reused:
SP_RENAME  'old table name', 'New table name'

For example,...

How to change the database collation

To change the collation of an database following commands can be used:

ALTER DATABASE [database name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE  [database name]  COLLATE Newcollation
ALTER DATABASE  [database name]  SET MULTI_USER

For example , suppose if the name...

SQL Triggers - An Introduction

Introduction
Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute...