Sfrgttk

Why do IPv6 unique local addresses have to have a /48 prefix?

What is this type of notehead called?

How do ground effect vehicles perform turns?

How does the reference system of the Majjhima Nikaya work?

Transformation of random variables and joint distributions

Can I sign legal documents with a smiley face?

Engineer refusing to file/disclose patents

How do you respond to a colleague from another team when they're wrongly expecting that you'll help them?

A social experiment. What is the worst that can happen?

Fuse symbol on toroidal transformer

What linear sensor for a keyboard?

Why we can't differentiate a polynomial equation as many times as we wish?

Translation of Scottish 16th century church stained glass

Do the concepts of IP address and network interface not belong to the same layer?

Is a model fitted to data or is data fitted to a model?

How much character growth crosses the line into breaking the character

Why did the EU agree to delay the Brexit deadline?

Do Legal Documents Require Signing In Standard Pen Colors?

About a little hole in Z'ha'dum

A Permanent Norse Presence in America

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

What major Native American tribes were around Santa Fe during the late 1850s?

THT: What is a squared annular “ring”?

List of people who lose a child in תנ"ך

Stored Procedure: How to tell if stored procedures conduct the same thing excluding Comments?

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 product same result. Is there anyway to convert stored procedures into binaries to validate they conduct the same thing? In essence, 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

asked 6 mins ago

GregThomas582GregThomas582

546

• 
  
  
  

  
  

  
  
  
  
  
  

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

  
  
  
  

add a comment | 

0

We are trying to compare stored procedure codes. Example, these two stored procedure codes product same result. Is there anyway to convert stored procedures into binaries to validate they conduct the same thing? In essence, 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

asked 6 mins ago

GregThomas582GregThomas582

546

• 
  
  
  

  
  

  
  
  
  
  
  

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

  
  
  
  

add a comment | 

We are trying to compare stored procedure codes. Example, these two stored procedure codes product same result. Is there anyway to convert stored procedures into binaries to validate they conduct the same thing? In essence, 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

asked 6 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

asked 6 mins ago

GregThomas582GregThomas582

546

share

asked 6 mins ago

GregThomas582GregThomas582

546

asked 6 mins ago

GregThomas582GregThomas582

546

asked 6 mins ago

GregThomas582GregThomas582

546