We are trying to compare stored procedure codes. Example, these two stored procedure codes produce the same result.
Is there a method to convert stored procedures into binaries to validate that they do the same?
(2) How would you know if the stored procedures are the same (fewer comments, line spaces and additional text)?
Context: we have just created an automatic code generator for the project (dimensions that change slowly). Comparing the new code generator with the oldest file code.
create procedure dbo.NumberSum as select 2 + 2 as SumDigits create procedure dbo.NumberSum as - Extra line comment select 2 + 2 as SumDigits