在SQL Server数据库中查找以小写字母开头的列，并将其作为SELECT语句列出

DECLARE @TableName NVARCHAR(128)
DECLARE @ColumnName NVARCHAR(128)
DECLARE @SQL NVARCHAR(MAX)

-- 创建一个临时表来存储结果
CREATE TABLE #TempColumns (
    TableName NVARCHAR(128),
    ColumnName NVARCHAR(128),
    SelectStatement NVARCHAR(MAX)
)

-- 遍历所有表
DECLARE TableCursor CURSOR FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'

OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName

WHILE @@FETCH_STATUS = 0
BEGIN
    -- 遍历表中的所有列
    DECLARE ColumnCursor CURSOR FOR
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = @TableName AND LEFT(COLUMN_NAME, 1) = LOWER(LEFT(COLUMN_NAME, 1))

    OPEN ColumnCursor
    FETCH NEXT FROM ColumnCursor INTO @ColumnName

    WHILE @@FETCH_STATUS = 0
    BEGIN
        -- 生成SELECT语句
        SET @SQL = 'SELECT ' + QUOTENAME(@ColumnName) + ' FROM ' + QUOTENAME(@TableName)
        INSERT INTO #TempColumns (TableName, ColumnName, SelectStatement)
        VALUES (@TableName, @ColumnName, @SQL)

        FETCH NEXT FROM ColumnCursor INTO @ColumnName
    END

    CLOSE ColumnCursor
    DEALLOCATE ColumnCursor

    FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor
DEALLOCATE TableCursor

-- 输出结果
SELECT * FROM #TempColumns

-- 删除临时表
DROP TABLE #TempColumns