Sfrgttk

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

sql-server sql-server-2016 stored-procedures

share

asked 6 mins ago

GregThomas582GregThomas582

546

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

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

asked 6 mins ago

GregThomas582GregThomas582

546

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

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