TSQLLoadQlikScript

/* ============================================================================
  Purpose:
  Generate Qlik Sense LOAD statements for every base table in the database.
  The script loops all tables and prints a ready-to-copy Qlik load block.
  ============================================================================ */
-- Holds the current table name while iterating
DECLARE @TABLE_NAME AS NVARCHAR(255);
-- Cursor used to loop through all tables
DECLARE @GenQlikLoad AS CURSOR;
-- Build cursor source: only base tables (exclude views)
SET @GenQlikLoad = CURSOR FOR
SELECT
   table_name
FROM INFORMATION_SCHEMA.TABLES
WHERE table_type = 'BASE TABLE';  -- Only get actual tables, not views
-- Start cursor and get first table
OPEN @GenQlikLoad;
FETCH NEXT FROM @GenQlikLoad INTO @TABLE_NAME;
-- Loop until no more tables are returned
WHILE @@fetch_status = 0
BEGIN
   BEGIN TRY
   	-- Suppress "(X rows affected)" messages for cleaner output
   	SET NOCOUNT ON;
   	
   	/* --------------------------------------------------------------------
   	   Build formatted column list for Qlik LOAD:
   	   - First column has no leading comma
   	   - Remaining columns are prefixed with comma
   	   - Preserves source column order using ORDINAL_POSITION
   	   -------------------------------------------------------------------- */
   	DECLARE @Columns NVARCHAR(MAX);
   	SELECT @Columns = STRING_AGG(
   		CASE
   			WHEN ORDINAL_POSITION = 1 THEN '     [' + column_name + ']'
   			ELSE '    ,[' + column_name + ']'
   		END,
   		CHAR(13) + CHAR(10)
   	) WITHIN GROUP (ORDER BY ORDINAL_POSITION)
   	FROM INFORMATION_SCHEMA.COLUMNS
   	WHERE table_name = @TABLE_NAME;
   	/* --------------------------------------------------------------------
   	   Print Qlik load block for current table.
   	   Example output:
   	     TableName:
   	     LOAD
   	          [Col1]
   	         ,[Col2]
   	     FROM Database.Schema.Table.qvd (qvd);
   	   -------------------------------------------------------------------- */
   	PRINT @TABLE_NAME + ':' + CHAR(13) + CHAR(10) + 'LOAD' + CHAR(13) + CHAR(10) +
   		  @Columns + CHAR(13) + CHAR(10) +
   		  'FROM ' + db_name() + '.' + SCHEMA_NAME() + '.' + @TABLE_NAME + '.qvd (qvd);' + CHAR(13) + CHAR(10) +
   		  '/////////////////////////////////////////////////////////////////////////////////////////////////';
   END TRY
   BEGIN CATCH
   	-- Log table-level error and continue to next table
   	PRINT 'Error processing table ' + @TABLE_NAME + ': ' + ERROR_MESSAGE();
   END CATCH
   -- Move to next table
   FETCH NEXT FROM @GenQlikLoad INTO @TABLE_NAME;
END
-- Cleanup cursor resources
CLOSE @GenQlikLoad;
DEALLOCATE @GenQlikLoad;