What does @RC mean in SSDT SQL Server Unit Testing?Unit testing of stored proceduresWhat does it mean if the...
VAT refund for a conference ticket in Sweden
Practical reasons to have both a large police force and bounty hunting network?
Didactic impediments of using simplified versions
I can't die. Who am I?
Is there a legal poaching?
How to evaluate the limit where something is raised to a power of x?
How do you say "powers of ten"?
At what level can a party fight a mimic?
What are the issues with an additional (limited) concentration slot instead of Bladesong?
What is this waxed root vegetable?
Skis versus snow shoes - when to choose which for travelling the backcountry?
Why are special aircraft used for the carriers in the united states navy?
Why can't we make a perpetual motion machine by using a magnet to pull up a piece of metal, then letting it fall back down?
Are paired adjectives bad style?
A bug in Excel? Conditional formatting for marking duplicates also highlights unique value
Test pad's ESD protection
Is there a frame of reference in which I was born before I was conceived?
Why do phishing e-mails use faked e-mail addresses instead of the real one?
Impact on website analytics caused by accessibility issues
Dredging in a fantasy setting
Where is the fallacy here?
Do higher etale homotopy groups of spectrum of a field always vanish?
Dystopian novel where telepathic humans live under a dome
Toast materialize
What does @RC mean in SSDT SQL Server Unit Testing?
Unit testing of stored proceduresWhat does it mean if the spt_monitor - table in SQL Server is empty?What does wait_resource LOG_MANAGER mean in SQL Server 2008?Sql Server Stored Procs vs Linq with C# and unit testingSQL Server - How to track down error thrown in SSDT publish preview?What does it mean that sp_who2 is not documented?SSDT Drop and Recreate Tables when nothing has changedHow does the Microsoft tablediff utility work?Reinitialize Table Values in SQL SSDT Unit TestingSQL Server Unit Testing, always set Scalar Value to 1 or Assert Statement
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.


sql-server sql-server-2016 ssdt visual-studio unit-test
New contributor
Joe Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
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.


sql-server sql-server-2016 ssdt visual-studio unit-test
New contributor
Joe Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
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.


sql-server sql-server-2016 ssdt visual-studio unit-test
New contributor
Joe Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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.


sql-server sql-server-2016 ssdt visual-studio unit-test
sql-server sql-server-2016 ssdt visual-studio unit-test
New contributor
Joe Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Joe Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 48 mins ago
Joe Smith
New contributor
Joe Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 hours ago
Joe SmithJoe Smith
134
134
New contributor
Joe Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Joe Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Joe Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
@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 scalarValue1 assertion will verify the return code value is 1 in order for the test to succeed.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Joe Smith is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f231400%2fwhat-does-rc-mean-in-ssdt-sql-server-unit-testing%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
@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 scalarValue1 assertion will verify the return code value is 1 in order for the test to succeed.
add a comment |
@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 scalarValue1 assertion will verify the return code value is 1 in order for the test to succeed.
add a comment |
@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 scalarValue1 assertion will verify the return code value is 1 in order for the test to succeed.
@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 scalarValue1 assertion will verify the return code value is 1 in order for the test to succeed.
answered 2 hours ago
Dan GuzmanDan Guzman
13.8k21735
13.8k21735
add a comment |
add a comment |
Joe Smith is a new contributor. Be nice, and check out our Code of Conduct.
Joe Smith is a new contributor. Be nice, and check out our Code of Conduct.
Joe Smith is a new contributor. Be nice, and check out our Code of Conduct.
Joe Smith is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f231400%2fwhat-does-rc-mean-in-ssdt-sql-server-unit-testing%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown