Regarding your problem of stored procedure comparison, Windiff is still available (just Google "windiff download", one of the places is Microsoft) so I'd have just used that (and regularly do!).

Of course,if you start writing your own tool, so you can ignore comments, then you are starting on a complex path since, ideally, you need to build a complete parser to check thatselect a,b,c from tblis equivalent toSELECT

d.a ,

d.b ,

d.c

FROM

tbl AS dor even thatselect a.a, b.b from a join b on a.c=b.cis the same asselect a.a, b.b from b join a on b.c=a.cAnd that's before comments have been introduced!

Sometimes the solution is just to use a simpler tool like Windiff along with the mk.1 Eyeball as used by an experience SQL writer. 😀