RSS feed

How to create a new table using existing tables

Published by: Sangeeta (2/6/2009 8:14:42 AM)

FEB 6 2009

I have to create a new table using the columns and records present in another tables. I can create the new table by writing the CREATE TABLE .... Query but as my database already has the tables with same column name, I want to reuse the column names as well as the records present in those columns.

Can anyone tell me the SQL Query for it?


I want to schedule a job in SQL Server 2008 >>

<< How to get records present in one table but not in other



You can use HTML tags here.
*Code: Please enter the sum of 5+2