deek
SSCommitted
Points: 1886
More actions
April 4, 2002 at 12:59 pm
#78292
I have two separate databases on the same server, and they use some overlapping data. What I want to know is: Can you set up a View in one database which contains data from the other database?
Steve Jones - SSC Editor
SSC Guru
Points: 736255
April 4, 2002 at 1:06 pm
#426629
yes,
create view N_orders as
select *
from northwind.dbo.orders
return
create this in pubs to access northwind.
Steve Jones
steve@dkranch.net
April 4, 2002 at 1:12 pm
#426632
Thanks alot. That was easy!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply