-
Multiple database query
Good afternoon one and all,
I want to write a query that will affect data across two databases (on the same server). How would I do this?
TIA for all help
Gurmi
-
Multiple database query (reply)
You can reference tables in difference databases by fully qualifying the tablename, for example
SELECT name FROM database1.dbo.table1
UNION
SELECT name FROM database2.dbo.table2
duncan
------------
gurmi at 12/4/00 6:08:30 AM
Good afternoon one and all,
I want to write a query that will affect data across two databases (on the same server). How would I do this?
TIA for all help
Gurmi
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|