Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
DECLARE @db_name VARCHAR(50)
DECLARE daterbass CURSOR FOR
SELECT [name] AS "dbname" FROM master..sysdatabases
ORDER BY "dbname"
OPEN daterbass
FETCH NEXT FROM daterbass
INTO @db_name
SET NOCOUNT ON
WHILE @@FETCH_STATUS = 0
BEGIN
SET @strQuery = 'SELECT colA, colB '
SET @strQuery = @strQuery + ' FROM ' + @db_name
SET @strQuery = @strQuery + + ' ..MyTable '
SET @strQuery = @strQuery + ' WHERE conditions'
EXECUTE(@strQuery)
FETCH NEXT FROM daterbass
INTO @db_name
END
CLOSE daterbass
DEALLOCATE daterbass
SET NOCOUNT OFF