Can I roll back a procedure execution?How can I remove duplicate rows?Insert results of a stored procedure into a temporary tableFunction vs. Stored Procedure in SQL ServerHow can I do an UPDATE statement with JOIN in SQL?How do I obtain a Query Execution Plan?Rolling Back A Transaction In T-SQL After Code Has Been ExecutedDatabase Transactions - Keeping some data from rolling backroll back a batch is not easy?Inner rollback transaction rolls back the outer tooTransaction in stored procedure not rolling back
Print the last, middle and first character of your code
Was I subtly told to resign?
What's the maximum time an interrupt service routine can take to execute on atmega328p?
In Parshas Chukas, why is first mention of Parah Adumah "פָרָה" instead of "פָּרָה"?
The monorail explodes before I can get on it
Is lack of functional requirements agile?
Is Arc Length always irrational between two rational points?
If the railway suggests a 5-min connection window for changing trains in the Netherlands, does that mean it's definitely doable?
Why didn't Thanos kill all the Dwarves on Nidavellir?
How can I deal with a player trying to insert real-world mythology into my homebrew setting?
Why does the autopilot disengage even when it does not receive pilot input?
During copyediting, journal disagrees about spelling of paper's main topic
references on the empirical study on the practice of OR
What was the definition of "set" that resulted in Russell's Paradox
Shortest distance around a pyramid?
What does "it kind of works out" mean?
As the Dungeon Master, how do I handle a player that insists on a specific class when I already know that choice will cause issues?
How can I get a player to accept that they should stop trying to pull stunts without thinking them through first?
Single word for "refusing to move to next activity unless present one is completed."
When did the Roman Empire fall according to contemporaries?
Why was hardware diversification an asset for the IBM PC ecosystem?
Who Can Help Retag This?
Did any of the founding fathers anticipate Lysander Spooner's criticism of the constitution?
Flatten array with OPENJSON: OPENJSON on a value that may not be an array? [ [1] ], vs [1]
Can I roll back a procedure execution?
How can I remove duplicate rows?Insert results of a stored procedure into a temporary tableFunction vs. Stored Procedure in SQL ServerHow can I do an UPDATE statement with JOIN in SQL?How do I obtain a Query Execution Plan?Rolling Back A Transaction In T-SQL After Code Has Been ExecutedDatabase Transactions - Keeping some data from rolling backroll back a batch is not easy?Inner rollback transaction rolls back the outer tooTransaction in stored procedure not rolling back
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
Can I roll back an executed procedure in a transaction?
Begin Transaction
Exec dbo.InsertIntoCustomerTable
Rollback Transaction
Is this valid?
tsql
edited Mar 26 at 6:36
a_horse_with_no_name
322k51 gold badges496 silver badges599 bronze badges
asked Mar 26 at 3:20
MikeMike
83 bronze badges
add a comment |
Can I roll back an executed procedure in a transaction?
Begin Transaction
Exec dbo.InsertIntoCustomerTable
Rollback Transaction
Is this valid?
tsql
edited Mar 26 at 6:36
a_horse_with_no_name
322k51 gold badges496 silver badges599 bronze badges
asked Mar 26 at 3:20
MikeMike
83 bronze badges
2
What are the results when you try it? Which db is being used?
– donPablo
Mar 26 at 3:46
1
Why don't you check it yourself? It's a really simple test after all...
– Zohar Peled
Mar 26 at 6:59
add a comment |
Can I roll back an executed procedure in a transaction?
Begin Transaction
Exec dbo.InsertIntoCustomerTable
Rollback Transaction
Is this valid?
tsql
edited Mar 26 at 6:36
a_horse_with_no_name
322k51 gold badges496 silver badges599 bronze badges
asked Mar 26 at 3:20
MikeMike
83 bronze badges
Can I roll back an executed procedure in a transaction?
Begin Transaction
Exec dbo.InsertIntoCustomerTable
Rollback Transaction
Is this valid?
tsql
tsql
edited Mar 26 at 6:36
a_horse_with_no_name
322k51 gold badges496 silver badges599 bronze badges
asked Mar 26 at 3:20
MikeMike
83 bronze badges
edited Mar 26 at 6:36
a_horse_with_no_name
322k51 gold badges496 silver badges599 bronze badges
asked Mar 26 at 3:20
MikeMike
83 bronze badges
edited Mar 26 at 6:36
a_horse_with_no_name
322k51 gold badges496 silver badges599 bronze badges
edited Mar 26 at 6:36
a_horse_with_no_name
322k51 gold badges496 silver badges599 bronze badges
edited Mar 26 at 6:36
a_horse_with_no_name
322k51 gold badges496 silver badges599 bronze badges
322k51 gold badges496 silver badges599 bronze badges
asked Mar 26 at 3:20
MikeMike
83 bronze badges
asked Mar 26 at 3:20
MikeMike
83 bronze badges
asked Mar 26 at 3:20
MikeMike
83 bronze badges
83 bronze badges
2
What are the results when you try it? Which db is being used?
– donPablo
Mar 26 at 3:46
1
Why don't you check it yourself? It's a really simple test after all...
– Zohar Peled
Mar 26 at 6:59
add a comment |
2
What are the results when you try it? Which db is being used?
– donPablo
Mar 26 at 3:46
1
Why don't you check it yourself? It's a really simple test after all...
– Zohar Peled
Mar 26 at 6:59
2
2
What are the results when you try it? Which db is being used?
– donPablo
Mar 26 at 3:46
What are the results when you try it? Which db is being used?
– donPablo
Mar 26 at 3:46
1
1
Why don't you check it yourself? It's a really simple test after all...
– Zohar Peled
Mar 26 at 6:59
Why don't you check it yourself? It's a really simple test after all...
– Zohar Peled
Mar 26 at 6:59
add a comment |
1 Answer
1
active
oldest
votes
Of course you can.
It is very useful to test procedure on production for any errors or model problems. The best way is to put TRY .... CATCH block and raport errors. That's great way to test procedure.
answered Mar 26 at 7:32
WhencesoeverWhencesoever
1,6818 silver badges19 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
);
);
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%2fstackoverflow.com%2fquestions%2f55349372%2fcan-i-roll-back-a-procedure-execution%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
Of course you can.
It is very useful to test procedure on production for any errors or model problems. The best way is to put TRY .... CATCH block and raport errors. That's great way to test procedure.
answered Mar 26 at 7:32
WhencesoeverWhencesoever
1,6818 silver badges19 bronze badges
add a comment |
Of course you can.
It is very useful to test procedure on production for any errors or model problems. The best way is to put TRY .... CATCH block and raport errors. That's great way to test procedure.
answered Mar 26 at 7:32
WhencesoeverWhencesoever
1,6818 silver badges19 bronze badges
add a comment |
Of course you can.
It is very useful to test procedure on production for any errors or model problems. The best way is to put TRY .... CATCH block and raport errors. That's great way to test procedure.
answered Mar 26 at 7:32
WhencesoeverWhencesoever
1,6818 silver badges19 bronze badges
Of course you can.
It is very useful to test procedure on production for any errors or model problems. The best way is to put TRY .... CATCH block and raport errors. That's great way to test procedure.
answered Mar 26 at 7:32
WhencesoeverWhencesoever
1,6818 silver badges19 bronze badges
answered Mar 26 at 7:32
WhencesoeverWhencesoever
1,6818 silver badges19 bronze badges
answered Mar 26 at 7:32
WhencesoeverWhencesoever
1,6818 silver badges19 bronze badges
answered Mar 26 at 7:32
WhencesoeverWhencesoever
1,6818 silver badges19 bronze badges
1,6818 silver badges19 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f55349372%2fcan-i-roll-back-a-procedure-execution%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
2
What are the results when you try it? Which db is being used?
– donPablo
Mar 26 at 3:46
1
Why don't you check it yourself? It's a really simple test after all...
– Zohar Peled
Mar 26 at 6:59