Versions Compared

Old Version 45

changes.mady.by.user Cindy Hall

Saved on

compared with

New Version 46

changes.mady.by.user Rachana Mannath

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this article

...

Info

  • You can drop your database with the execution, so we recommend you to be cautious.

  • You can execute stored procedures containing IN, OUT, INOUT parameters using this Snap.

...

Snap Type

SQL Server - Execute Snap is a Write-type Snap that executes an SQL Server statement/query.

...

Error

Reason

Resolution

Failure: Batch operation failed. Error code: 102

Incorrect syntax near 'GO'.

Rewrite the query without ‘GO’ and run it.

Example

In this example, we have a table named "customer1" that stores user details. It has the columns: product, phoneno, customername, city, country. We will execute the query and retrieve customers with given name.

...