How to create a new table using existing tables

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

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?

 

Most Popular Articles

• SQL Server 2008 Error: is not a valid login or you do not have permission
• Cannot start .aspx
• what is the difference between Text and String Data type in SQL Server
• Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Why my MS SQL Server 2005 DSN Connection is not Working

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

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