how to copy data from one table to another table in another database

 Posted by Nimanapallisharat on 6/26/2014 | Category: Sql Server Interview questions | Views: 547 | Points: 40
Answer:

select * into desti.dbo.new from sourc.dbo.table;

here in above query
desti means name of the database where you want to create new table.
new means name of the new table in which you copy the data.
source means name of the database from where your table is located.

table means name of the table from which you take the data for copying.
dbo means database object


Source: training classes | Asked In: some Interviews | Alert Moderator 

Comments or Responses

Login to post response

More Interview Questions by Nimanapallisharat