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
- what is the difference between Text and String Data type in SQL Server
- Cannot start .aspx
- Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
- Why my MS SQL Server 2005 DSN Connection is not Working