Monday, September 24, 2012

SSMA error message S2SS0075

Unable to convert Cursor error message

                    We cannot assign the value to the variable in cursor select statement,followed by the declaration of the cursor 
                    While assigning into variable in the cusrsor declaration leads to error.We can remove this assignment from declaration,because fetch statement should have the assignment for the output.Removal of this assignment wont create an issue.
                      I have placed sample cursor declaration with assignment along with corresponding error.

Cursor declaration with assignment





















Cursor declaration without assignment:

Cursor declaration without assignment
























We can use the above given screenshot to resolve S2SS0075.

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

No comments:

Post a Comment