how can copy 1 database table data to another database table

Question

how can copy one database table data to another database table in porgramaticaly plz send idea or example

Riddhi Valecha · Answer

Hi.. Right-Click on table -> Script Table As -> Create To -> New Window -- In the window, change database name/ Database - 1st Line USE [DatabaseName]

Najim Mulla · Answer

aouthotication error

Ravi Kumar · Answer

what error

Najim Mulla · Answer

error created athoticate error display masage

Ravi Kumar · Answer

no problem example given below create procedure procedurename as begin insert into databasename2.dbo.secondtablename(columns1,column2)(select column1,column2 from databasename1.dbo.firsttablename) end

Najim Mulla · Answer

same server in online database

Ravi Kumar · Answer

same server or different server server also different or what

Najim Mulla · Answer

different

Ravi Kumar · Answer

no. both are in same database or different database. server same or different

Najim Mulla · Answer

password protected both database

Ravi Kumar · Answer

hi use the store procedure example given below create procedure procedurename as begin insert into secondtablename(columns1,column2)(select column1,column2 from firsttablename) end

how can copy 1 database table data to another database table

Answers (11)