August 27, 2012 by Er.Hem Raj Thakur
Hi friends, this is Er.Hem Raj Thakur. I’m a software tester at web n soft solutions ambala cantt.
- To Create a Table From one database to another with same data
select * into NEW DATABASE.dbo.New Table from OLD DATABASE.dbo.OLD Table
the second query is this when user has already same table and same column name in a table in other database and user want to enter the new record in a table. Then this query will be helpful for those.
INSERT into DB_Glass_Cal2.dbo.tbl_Certificate select * from DB_Glass_Cal.dbo.tbl_Certificate