MS SQL SERVER char 函数显示ASCII的效果

DECLARE @I INT
DECLARE @SQL NVARCHAR(max)
DECLARE @EXECSQL NVARCHAR(200)
DECLARE @RESULT NVARCHAR(MAX)
SET @I= 
SET @SQL = 'SELECT ' 

WHILE @I<
BEGIN
    SET @EXECSQL = 'SELECT ''TXT1'' + CHAR(' + CAST(@I AS NVARCHAR()) + ') + ''TXT2'' AS CHAR' +CAST(@I AS NVARCHAR())
    PRINT @EXECSQL
    EXEC SP_EXECUTESQL @EXECSQL

    SET @SQL = @SQL + '''TXT1'' + CHAR(' + CAST(@I AS NVARCHAR()) + ') + ''TXT2'' AS CHAR' +CAST(@I AS NVARCHAR()) + ','
    SET @[email protected]+
END
PRINT LEFT(@SQL,LEN(@SQL)-)
SET @RESULT = LEFT(@SQL,LEN(@SQL)-)
EXEC SP_EXECUTESQL @RESULT