Thursday, September 27, 2012

SSMA error message S2SS0015


Unparsed SQL [ZERO:] cannot be converted:

               SSMA raises above given error, while migrating the 'GOTO' Transact sql.
Though SSMA raises the error,both Sybase and SQL Server will get execute the code successfully along with GOTO.To maintain the best practice,readability we should convert the 'GOTO' Control statement into IF....ELSE,Nested IF or any other Control statement.I have placed sample code with GOTO Statement along with the output.


Below given sample code will give the same result without GOTO to follow best practice.Try to avoid GOTO statement in the program.


Please click here to know about sybase to sql server migration issues

No comments:

Post a Comment