Execute Stored Procedure before test

We can execute stored procedure before test

-- RUN STORED PROCEDURE

EXEC dbo.test_proc;

-- SELECT ACTUAL DATA FROM DATABASE

SELECT *
FROM
	[country];

Store Procedure cannot return results set.

<cmpSqlResultsTest>
    <compare mode="FILE" diffTableSize="5" chunk="1000" fileOutputOn="true">
        <sql datasourceName="AZURE_SYNAPSE" filename="sql1.sql" />
        <!-- separator -> CSV file separtor. Default is "," -->
        <file filename="fileSource.csv" separator=";" startAtRow="1" />
    </compare>
</cmpSqlResultsTest>