= "SELECT * FROM " & JOIN(Parameters!DatabasesOnServer.Value) & ".sys.tables

SELECT * FROM [DataBaseNameGoesHere].[sys].[tables] AS T

= "SELECT * FROM " & JOIN(Parameters!DatabasesOnServer.Value) & ".sys.tables

SELECT * FROM [DataBaseNameGoesHere].[sys].[tables] AS T

DECLARE @dbnames TABLE
	(
	  id TINYINT IDENTITY(1, 1)
				 NOT NULL
	, dbnames VARCHAR(150) NOT NULL
	)
INSERT INTO @dbnames
		(
		  [dbnames] 
		)
		SELECT
				[name]
			FROM
				sys.[databases] AS D
			WHERE
				[database_id] > 4
DECLARE
	@counter INT = 1
  , @maxRecordsToProcess INT
SET @maxRecordsToProcess = (
							 SELECT
									COUNT(*)
								FROM
									@dbnames
						   )

DECLARE @dsql NVARCHAR(MAX)
WHILE @counter <= @maxRecordsToProcess 
	BEGIN
		DECLARE @dbname VARCHAR(150) = (
										 SELECT TOP 1
												dbnames
											FROM
												@dbnames
											WHERE
												@counter = id
									   )
		SELECT
				@dsql = 'SELECT * FROM ' + @dbname + '.[sys].[tables] AS T'
				EXEC [sys].[sp_executesql] @dsql
		
		SET @counter += 1
	END