SQL Server Query Help For Everyone.

Leave a comment

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.

  1. 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: