Iterate through the database name with a cursor, open the database one by one to implement the cross-Library query

DECLARE @SQL VARCHAR (MAX)

DECLARE test_cursor Cursor

SCROLL for

SELECT pfdb_no from dbo. Pfdbinfotable

OPEN Test_cursor

DECLARE @PFDBNo nchar (11)

FETCH NEXT from Test_cursor to @PFDBNo

While

@ @FETCH_STATUS =0

BEGIN

PRINT @PFDBNo

SET @SQL = ' SELECT * from ' [email protected]+ '. dbo. Barnotable ' EXEC (@SQL)

FETCH NEXT from Test_cursor to @PFDBNo END

CLOSE Test_cursor

Deallocate test_cursor

Iterate through the database name with a cursor, open the database one by one to implement the cross-Library query