How can we help you today? How can we help you today?

How to disable semicolons when comparing

Hello

I am doing a comparison between 2 database, and one of the database always have a semicolon between any END and GO commands, while another does not.

this causes more than 300 differences that shouldn't. How do I resolve this? Thanks.

i.e

CREATE TRIGGER [Data].[TR_I_]
ON [Data].[vA]
INSTEAD OF INSERT
AS

BEGIN

//codes

END

;

GO
CREATE TRIGGER [Data].[TR_U]
INSTEAD OF UPDATE
AS

BEGIN

//codes

END

;
teasmith
0

Comments

1 comment

Add comment

Please sign in to leave a comment.