Unparsed SQL, cannot converted
Please Check the Script to satisfy the following best practices to avoid the S2SS0015 error message.
1.Required space should be there,in between column and sql server keywords.
2.Check wether,given keywords available in sql server.
3.Need to check,variable declaration is correct.
4.Check for syntax error.
INSERTINTO #temp_swtch
( column1,
column2,
column3)
VALUES (
( column1,
column2,
column3)
VALUES (
'first value',
'second value',
1 )
'second value',
1 )
In the above given statement,Space character missing between INSERT and INTO.
If we change the statement like below we can resolve the S2SS0015 Error.
INSERT INTO #temp_swtch
( column1,
column2,
column3)
VALUES (
( column1,
column2,
column3)
VALUES (
'first value',
'second value',
1 )
Please click here to know about sybase to sql server migration issues
'second value',
1 )
Please click here to know about sybase to sql server migration issues
No comments:
Post a Comment