HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

What does @RC mean in SSDT SQL Server Unit Testing?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
whatsqlmeanssdttestingdoesserverunit

Problem

In Sql Server Unit Testing, SSDT, what does @RC stand for? Does it mean Row Count, or Row Column? Team wants to understand, we have been using it for long time, good tool which works, just curious.

Solution

@RC = Return code. The boilerplate unit test code will assign the stored procedure return code value to this variable, where it can later be used in a test case assertion.

Assuming there's a subsequent SELECT @RC after the proc execution in the unit test code, the scalarValueCondition1 assertion in your screen image will verify the return code value is 1 in order for the test to succeed.

Context

StackExchange Database Administrators Q#231400, answer score: 5

Revisions (0)

No revisions yet.