Sfrgttk

How should I respond when I lied about my education and the company finds out through background check?

A Permanent Norse Presence in America

How do I repair my stair bannister?

Can somebody explain Brexit in a few child-proof sentences?

What is the gram­mat­i­cal term for “‑ed” words like these?

Could solar power be utilized and substitute coal in the 19th Century

What's the difference between 違法 and 不法?

How to decide convergence of Integrals

Could the E-bike drivetrain wear down till needing replacement after 400 km?

Do varchar(max), nvarchar(max) and varbinary(max) columns affect select queries?

Can I sign legal documents with a smiley face?

Is XSS in canonical link possible?

My friend sent me a screenshot of a transaction hash, but when I search for it I find divergent data. What happened?

Will adding a BY-SA image to a blog post make the entire post BY-SA?

Customize circled numbers

How much character growth crosses the line into breaking the character

Freedom of speech and where it applies

THT: What is a squared annular “ring”?

Divine apple island

Create all possible words using a set or letters

Difference between -| and |- in TikZ

Varistor? Purpose and principle

What linear sensor for a keyboard?

Did arcade monitors have same pixel aspect ratio as TV sets?

Stored Procedure: How remove Comments, spaces, and extra lines, or companies binaries?

sp_executesql adds statements to executed dynamic script?Convert all ntext columns to nvarchar(max)Can comments in stored procedures cause problemsCreate/Alter stored procedure without compilingMoving data from MS Access to MS SQL ServerSame code in multiple stored proceduresMySQL stored procedure fails to populate first column, gives strange errorMySQL reusable results as table with parametersHow to find Stored Procedures With Recompile?How to Develop Union Reports from Single Tenant Databases?

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)?

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|improve this question

edited 26 secs ago

GregThomas582

asked 11 mins ago

GregThomas582GregThomas582

546

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The one without comments is non-maintainable. I would ignore it.
  
  – Michael Kutz
  6 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  well just trying to strip comments from stored procedures
  
  – GregThomas582
  2 mins ago
  

  
  
  
  

add a comment | 

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)?

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|improve this question

edited 26 secs ago

GregThomas582

asked 11 mins ago

GregThomas582GregThomas582

546

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The one without comments is non-maintainable. I would ignore it.
  
  – Michael Kutz
  6 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  well just trying to strip comments from stored procedures
  
  – GregThomas582
  2 mins ago
  

  
  
  
  

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)?

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|improve this question

edited 26 secs ago

GregThomas582

asked 11 mins ago

GregThomas582GregThomas582

546

create procedure dbo.NumberSum

as

select 2 + 2 as SumDigits





create procedure dbo.NumberSum

as

-- Extra line comment

select 2 + 2 as SumDigits

share|improve this question

edited 26 secs ago

GregThomas582

asked 11 mins ago

GregThomas582GregThomas582

546

share|improve this question

edited 26 secs ago

GregThomas582

asked 11 mins ago

GregThomas582GregThomas582

546

asked 11 mins ago

GregThomas582GregThomas582

546

asked 11 mins ago

GregThomas582GregThomas582

546