ViewState with example in C#

Monday, January 31, 2011

How to copy data from one table to another table in sql server

Syntax:- select * into NewTableName from ExistingTableName

Example:- select * into employee1 from employee

Note: where employee is the existing table. this query create a new table (employee1) and copy all the data of employee table in newly created table

        I hope this will help you!!

No comments:

Post a Comment