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 |