var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to insert all info from a table of database to onther table of other database?
I have two database and both of them has the same table, i want to copy all info from this first table to the secornd table
Database : DB_1, table is table_1
Database : DB_2, table is table_2
both table_1 and table_2 have the same struct
how can i insert all records from table_1 to table_2
You can use DTS by using wizard from enterprise manager, if its one-off option.
Otherwise schedule that package as a job oto execute in periodic basis.
if it is just one table and one time affair, then u can just import the data from EM using the import wizard.
Thanks but i do it by programming SQL or C# language
can you show me in programming
Use a SELECT subquery to specify the data values for one or more rows.
INSERT INTO MyTable (PriKey, Description)
SELECT ForeignKey, Description
And review information from SQL books online.