Skip to main content
Question

SQLExecutor + Stored Procedure in MSSQL: Executed or not?

  • November 15, 2012
  • 2 replies
  • 10 views

sigtill
Contributor
Forum|alt.badge.img+24
When using the SQLExecutor with a Normal SQL like:

 

SELECT *

 

FROM mytable

 

WHERE id LIKE 11111

 

 

It will return an attribute "_matched_records" with the number of records matched in from TRIGGER port.

 

 

However when using an EXEC-statement this does not seem to happen. Like this:

 

EXEC @return_value = [dbo].[myStoredProcedure] @ID = N'@Value(IID)',

 

@myTableValue = N'@Value(myValue)',

 

 

 

So after doing this it is not possible to figure out if the EXEC have actually run and inserted the needed attribute - or if there is an error performing this request. Anyone with a good workaround OTHER than doing another SQLExecutor to try to read back the data and try to compare the features? (Many features = alot of time reading and writing)

2 replies

sigtill
Contributor
Forum|alt.badge.img+24
  • Author
  • Contributor
  • November 15, 2012
A thank you goes to Ken Bragg that helped solve this issue. The solution was to add SET NOCOUNT ON; on the StoredProcedure.

fmelizard
Contributor
Forum|alt.badge.img+17
  • Contributor
  • November 15, 2012
Although I have to admit - I stumbles upon that while doing a really complicated work-around. Luck!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings