Table copy in MS SQL

Copy data of a table to other table or to the other data base:



begin transaction
    select *
    into Practice.dbo.temp       --name of new table that you want to create
    from moin.dbo.Bank          --Existing table name
go