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













0















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








share



























    0















    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








    share

























      0












      0








      0








      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








      share














      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





      share












      share










      share



      share










      asked 6 mins ago









      GregThomas582GregThomas582

      546




      546






















          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
          });


          }
          });














          draft saved

          draft discarded


















          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
















          draft saved

          draft discarded




















































          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.




          draft saved


          draft discarded














          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





















































          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







          Popular posts from this blog

          Anexo:Material bélico de la Fuerza Aérea de Chile Índice Aeronaves Defensa...

          Always On Availability groups resolving state after failover - Remote harden of transaction...

          update json value to null Announcing the arrival of Valued Associate #679: Cesar Manara ...