Split SQL Script By Go With Exceptions
I have a SQL script that I need to run using my .NET app. The script contains various commands separated by "GO". To separate the commands, I am using the Split() function:
var sqlqueries = Script.Split(new { " GO ", "GO" }, StringSplitOptions.RemoveEmptyEntries);
The problem is that my scripts contain columns and tables with the word "CATEGORY" in them.
Is there any way to add exceptions to the .Split function? If not, what are my options? (I've seen Regex, but have no idea how to use it)
c# .net
asked Nov 21 '18 at 1:07
useruser
92522
add a comment |
I have a SQL script that I need to run using my .NET app. The script contains various commands separated by "GO". To separate the commands, I am using the Split() function:
var sqlqueries = Script.Split(new { " GO ", "GO" }, StringSplitOptions.RemoveEmptyEntries);
The problem is that my scripts contain columns and tables with the word "CATEGORY" in them.
Is there any way to add exceptions to the .Split function? If not, what are my options? (I've seen Regex, but have no idea how to use it)
c# .net
asked Nov 21 '18 at 1:07
useruser
92522
add a comment |
I have a SQL script that I need to run using my .NET app. The script contains various commands separated by "GO". To separate the commands, I am using the Split() function:
var sqlqueries = Script.Split(new { " GO ", "GO" }, StringSplitOptions.RemoveEmptyEntries);
The problem is that my scripts contain columns and tables with the word "CATEGORY" in them.
Is there any way to add exceptions to the .Split function? If not, what are my options? (I've seen Regex, but have no idea how to use it)
c# .net
asked Nov 21 '18 at 1:07
useruser
92522
I have a SQL script that I need to run using my .NET app. The script contains various commands separated by "GO". To separate the commands, I am using the Split() function:
var sqlqueries = Script.Split(new { " GO ", "GO" }, StringSplitOptions.RemoveEmptyEntries);
The problem is that my scripts contain columns and tables with the word "CATEGORY" in them.
Is there any way to add exceptions to the .Split function? If not, what are my options? (I've seen Regex, but have no idea how to use it)
c# .net
c# .net
asked Nov 21 '18 at 1:07
useruser
92522
asked Nov 21 '18 at 1:07
useruser
92522
edited Nov 21 '18 at 1:10
user
asked Nov 21 '18 at 1:07
useruser
92522
asked Nov 21 '18 at 1:07
useruser
92522
asked Nov 21 '18 at 1:07
useruser
92522
92522
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You may split on GO separated by word boundaries:
var sqlqueries = Regex.Split(Script, @"bGOb");
Note that this might generate an empty extra final entry in the output array, assuming your final query ends with GO, but does not have another query after it. But, this can easily enough be dealt with.
answered Nov 21 '18 at 1:09
Tim BiegeleisenTim Biegeleisen
221k1388141
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%2f53403905%2fsplit-sql-script-by-go-with-exceptions%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
You may split on GO separated by word boundaries:
var sqlqueries = Regex.Split(Script, @"bGOb");
Note that this might generate an empty extra final entry in the output array, assuming your final query ends with GO, but does not have another query after it. But, this can easily enough be dealt with.
answered Nov 21 '18 at 1:09
Tim BiegeleisenTim Biegeleisen
221k1388141
add a comment |
You may split on GO separated by word boundaries:
var sqlqueries = Regex.Split(Script, @"bGOb");
Note that this might generate an empty extra final entry in the output array, assuming your final query ends with GO, but does not have another query after it. But, this can easily enough be dealt with.
answered Nov 21 '18 at 1:09
Tim BiegeleisenTim Biegeleisen
221k1388141
add a comment |
You may split on GO separated by word boundaries:
var sqlqueries = Regex.Split(Script, @"bGOb");
Note that this might generate an empty extra final entry in the output array, assuming your final query ends with GO, but does not have another query after it. But, this can easily enough be dealt with.
answered Nov 21 '18 at 1:09
Tim BiegeleisenTim Biegeleisen
221k1388141
You may split on GO separated by word boundaries:
var sqlqueries = Regex.Split(Script, @"bGOb");
Note that this might generate an empty extra final entry in the output array, assuming your final query ends with GO, but does not have another query after it. But, this can easily enough be dealt with.
answered Nov 21 '18 at 1:09
Tim BiegeleisenTim Biegeleisen
221k1388141
edited Nov 21 '18 at 1:15
answered Nov 21 '18 at 1:09
Tim BiegeleisenTim Biegeleisen
221k1388141
answered Nov 21 '18 at 1:09
Tim BiegeleisenTim Biegeleisen
221k1388141
answered Nov 21 '18 at 1:09
Tim BiegeleisenTim Biegeleisen
221k1388141
221k1388141
add a comment |
add a comment |
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%2f53403905%2fsplit-sql-script-by-go-with-exceptions%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
