How to Create a New Table From Another Table in Sql Server or Copy Table Structure As well as Data?

 Posted by vishalneeraj-24503 on 10/7/2014 | Category: Sql Server Interview questions | Views: 298 | Points: 40
Answer:

Use below script:-
For Example:-
Select * INTO New_Tbl From Existing_Tbl;

It will copy all data along with all columns.
If we want to copy specific rows then give valid condition,so that where condition will satisfy.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response