我有一个存储过程，并且是使用UNION创建的；我如何计算总行数？

SELECT COUNT(*) FROM my_procedure;

CREATE TEMPORARY TABLE temp_table AS
SELECT * FROM my_procedure;

SELECT COUNT(*) FROM temp_table;

DECLARE @row_count INT = 0;
DECLARE @cursor CURSOR FOR
SELECT * FROM my_procedure;

OPEN @cursor;

FETCH NEXT FROM @cursor INTO ...;

WHILE @@FETCH_STATUS = 0
BEGIN
    SET @row_count = @row_count + 1;
    FETCH NEXT FROM @cursor INTO ...;
END;

CLOSE @cursor;
DEALLOCATE @cursor;

SELECT @row_count;