I found out that the "GOTO"-statement (T-SQL) in not possible in SQL-Scripts.
(MS-SQLServer)
Do I have to change all my scripts or is there a workaround?
when executing an SQL-Script like this: update table1 set xxx='new_value' from table1 where xxx='old_value AI reports the Error "SQLExecDirect {SQL no data}" and stops executing. This is only the case when there are no rows selected to update.
I have the same Problem with SQL Server 2005 and SQL Server 7, so I know the problem doesnt come with the Server-version. When I use the statement separator "GO" I get this error message: SQLExecDirect {SQL Error}: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'TABLE'.
FOLLOW US
Get the latest news in Application Packaging