SQL Server

Magic Table in SQL Server

SQL Server allows us to define a Magic Table. Magic tables are nothing but invisible tables or virtual...

TRIGGERS

A trigger is a special type of procedure that will used to provide restrict on the tables and...

SQL Server Identity Functions

Introduction: In SQL Server IDENTITY column is a special type of column that used to generate out-increment key...

Tips and Tricks to Create New Table from Existing Table

Here I want to discuss how to create new table from existing table by using SQL statement In...