Loading

Get data from multiple databases into single store procedure

Get data from multiple databases into single store procedure

Atul Patil

Atul Patil

10y865

I want count the users of three databases into a single store procedure?How it possible?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp10y ago
Accepted answer
Hi,
You can try like below -
SELECT * FROM DB1.dbo.MyTable UNION ALL SELECT * FROM DB2.dbo.MyTable
0
Ananth G10y ago
1. SELECT*
2. FROM[MyDatabaseOnDB1].[dbo].[MyTable]tab1
3. INNERJOIN[DB2].[MyDatabaseOnDB2].[dbo].[MyOtherTable]tab2
4. ONtab1.ID=tab2.ID
U can use like this
0

Manas Mohapatra

Manas Mohapatra10y ago

Try like below:

SELECT
DB_NAME(dbid) as DBName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
FROM
sys.sysprocesses
WHERE
dbid > 0
GROUP BY
dbid, loginame

Note: If you want Database specific then add filter in where condition.

0