"CREATE PROCEDURE" vs "CREATE PROC"

Brian DonahueBrian Donahue Posts: 6,590 New member
edited June 23, 2004 10:21AM in SQL Compare Previous Versions
Hi Alex,

There isn't an option in SQL Compare to ignore the differences in a SQL
statement where you substitute PROC and PROCEDURE. I've passed the
suggestion on, though, and it may appear in a future version if it's
practical to do.

Regards,

Brian Donahue
Red Gate Technical Support

"Alex Rabinovich" <[email protected]> wrote in message
news:[email protected]
> SQL Compare considers two stored procedures being different even if the
only
> difference is between "PROCEDURE" and "PROC" keywords as in:
>
> '''''''
> CREATE PROCEDURE usp_myProc
> AS
> SELECT 1
>
> ''''''
> CREATE PROC usp_myProc
> AS
> SELECT 1
>
> Is there any option in SQLCompare to consider "PROCEDURE" and "PROC" to be
> the same keywords?
>
> Thanks
> Alex
>
>
This discussion has been closed.