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