upadate database1.table1 wirh values from database2.table1
upadate database1.table1 wirh values from database2.table1
Last Comment
ASKER
Invalid object name database1.dbo.table1. Where table1 is the new table on the first database
sorry
You have to use the server name
insert into [server1].[database1].[dbo
select * from table2
You have to use the server name
insert into [server1].[database1].[dbo
select * from table2
ASKER
use database2
insert into server.database.dbo.orderi
select * from orderitems
Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'server.database.dbo.order
table orderitems123 has not be created
use database2
insert into purchase.ow1222.dbo.orderi
select * from orderitems
Invalid object name 'database.dbo.orderitems12
insert into server.database.dbo.orderi
select * from orderitems
Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'server.database.dbo.order
table orderitems123 has not be created
use database2
insert into purchase.ow1222.dbo.orderi
select * from orderitems
Invalid object name 'database.dbo.orderitems12
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Create a linked database then you can use this format
insert into database1.dbo.table1
select * from database2.dbo.table2