In this article
...
When the SQL statement property is an expression, the pipeline parameters are shown in the suggest, but not the input schema.
Behavior Change
As part of
436patches25696
, when you use a stored procedure in the SQL Server - Execute Snap, the Snap displaysMessage: Success
and$UPDATE_COUNT=-1, 0, or 1
(based on the Snap Pack behavior) in the output.
Snap Views
Type | Format | Number of Views | Examples of Upstream and Downstream Snaps | Description | ||
---|---|---|---|---|---|---|
Input | Document |
|
| This Snap allows zero or one input views. If the input view is defined, then the where clause can substitute incoming values for a given expression. | ||
Output | Document |
|
| This Snap allows zero or one output view and produces documents in the view. | ||
Error | Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab:
Learn more about Error handling in Pipelines.
|
...
Error | Reason | Resolution |
---|---|---|
| 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.
...