Stored Procedure: How remove Comments, spaces, and extra lines, or companies binaries?Help with stored...
Does the Mind Blank spell prevent the target from being frightened?
Drawing a topological "handle" with Tikz
Can I sign legal documents with a smiley face?
Could the E-bike drivetrain wear down till needing replacement after 400 km?
Some numbers are more equivalent than others
What is this type of notehead called?
Bob has never been a M before
What's the difference between 違法 and 不法?
Is it possible to use .desktop files to open local pdf files on specific pages with a browser?
How to color a curve
How will losing mobility of one hand affect my career as a programmer?
Freedom of speech and where it applies
What is the difference between "Do you interest" and "...interested in" something?
List of people who lose a child in תנ"ך
Greco-Roman egalitarianism
About a little hole in Z'ha'dum
Proof of Lemma: Every nonzero integer can be written as a product of primes
Reply 'no position' while the job posting is still there
Visiting the UK as unmarried couple
Varistor? Purpose and principle
Customize circled numbers
How do you respond to a colleague from another team when they're wrongly expecting that you'll help them?
Translation of Scottish 16th century church stained glass
We have a love-hate relationship
Stored Procedure: How remove Comments, spaces, and extra lines, or companies binaries?
Help with stored procedure and update tableHow to create a dummy Linked Server in SQL Server 2012deteriorating stored procedure running timesAsynchronous database inserts from C# always result in a deadlockPermissions on views/stored procedures and the referenced base tables in linked serversMySQL stored procedure fails to populate first column, gives strange errorstored procedure with input and output parametersStored Procedure triggered by Service Broker can't access another database in SQLServer 2017Stored procedure or Table Function doesn't return value when parsing XML
We are trying to compare stored procedure codes. Example, these two stored procedure codes produce same result.
(1)
Is there method to convert stored procedures into binaries to validate they conduct the same thing?
(2) How would i tell if stored procedures are the same (minus comments, line spaces, and extra text)?
Context: we just created an auto code generator for project (Slowly changing dimensions). Comparing new code generator with older archive code.
create procedure dbo.NumberSum
as
select 2 + 2 as SumDigits
create procedure dbo.NumberSum
as
-- Extra line comment
select 2 + 2 as SumDigits
sql-server sql-server-2016 stored-procedures
add a comment |
We are trying to compare stored procedure codes. Example, these two stored procedure codes produce same result.
(1)
Is there method to convert stored procedures into binaries to validate they conduct the same thing?
(2) How would i tell if stored procedures are the same (minus comments, line spaces, and extra text)?
Context: we just created an auto code generator for project (Slowly changing dimensions). Comparing new code generator with older archive code.
create procedure dbo.NumberSum
as
select 2 + 2 as SumDigits
create procedure dbo.NumberSum
as
-- Extra line comment
select 2 + 2 as SumDigits
sql-server sql-server-2016 stored-procedures
add a comment |
We are trying to compare stored procedure codes. Example, these two stored procedure codes produce same result.
(1)
Is there method to convert stored procedures into binaries to validate they conduct the same thing?
(2) How would i tell if stored procedures are the same (minus comments, line spaces, and extra text)?
Context: we just created an auto code generator for project (Slowly changing dimensions). Comparing new code generator with older archive code.
create procedure dbo.NumberSum
as
select 2 + 2 as SumDigits
create procedure dbo.NumberSum
as
-- Extra line comment
select 2 + 2 as SumDigits
sql-server sql-server-2016 stored-procedures
We are trying to compare stored procedure codes. Example, these two stored procedure codes produce same result.
(1)
Is there method to convert stored procedures into binaries to validate they conduct the same thing?
(2) How would i tell if stored procedures are the same (minus comments, line spaces, and extra text)?
Context: we just created an auto code generator for project (Slowly changing dimensions). Comparing new code generator with older archive code.
create procedure dbo.NumberSum
as
select 2 + 2 as SumDigits
create procedure dbo.NumberSum
as
-- Extra line comment
select 2 + 2 as SumDigits
sql-server sql-server-2016 stored-procedures
sql-server sql-server-2016 stored-procedures
asked 6 mins ago
GregThomas582GregThomas582
546
546
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
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%2f232969%2fstored-procedure-how-remove-comments-spaces-and-extra-lines-or-companies-bin%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f232969%2fstored-procedure-how-remove-comments-spaces-and-extra-lines-or-companies-bin%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