sql-server - 如何在游标查询中使用 SQL 查询？

Question

我想通过根据以下 SQL 查询问题的值返回类(class)问题来获取输出。我想记录这个打印。我怎样才能做到这一点？感谢您的帮助。

SQL查询:

SELECT 
    [NoMatchExplanation],
    COUNT(*)
FROM 
    err.CustomerBank
GROUP BY 
   (NoMatchExplanation)

光标查询:

DECLARE cr_Read CURSOR FOR
   SELECT TABLE_SCHEMA + '.' + TABLE_NAME
   FROM INFORMATION_SCHEMA.TABLES 
   WHERE TABLE_SCHEMA = 'err'

DECLARE @name NVARCHAR(100)

OPEN cr_Read

FETCH NEXT FROM cr_Read INTO @name

WHILE @@FETCH_STATUS = 0   
BEGIN
    INSERT INTO etl.ErrorTable VALUES (@name)

    FETCH NEXT FROM cr_Read INTO @name
END

CLOSE cr_Read
DEALLOCATE cr_Read

Answer 1

只需这样做:

INSERT INTO etl.ErrorTable
   SELECT TABLE_SCHEMA + '.' + TABLE_NAME
   FROM INFORMATION_SCHEMA.TABLES 
   WHERE TABLE_SCHEMA = 'err';