hy, i have 2 database. DB1 & DB2.
i create SP in DB1. in the SP, i want to access table "TBL" in DB2.
how can i create that SP??
CREATE PROCEDURE test
AS
BEGIN
??????????
END;Thx,
am_dumb
2
Newbie Poster
Recommended Answers
Jump to PostThe syntax
SELECT * FROM [DATABASENAME].[SCHEMA].[TABLE]So let's say you're in the Northwind database and you wanted to query a table in the Pubs database, you would do the following:
SELECT * FROM Pubs.dbo.Authors
All 2 Replies
samaru
145
a.k.a inscissor
Team Colleague
The syntax
SELECT * FROM [DATABASENAME].[SCHEMA].[TABLE]So let's say you're in the Northwind database and you wanted to query a table in the Pubs database, you would do the following:
SELECT * FROM Pubs.dbo.Authors
am_dumb
2
Newbie Poster
thx,
its work!!
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.