NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

How to execute a store procedure using the database steps?

Solved!
Go to solution

Hi,

I'm trying to execute some store procedures and it won't work.

See the attached seq file.

 

I have a varchar(50) parameter which should also be supplied to the stored procedure and it will return an int.

 

0 Kudos
Message 1 of 4
(3,682 Views)

I did solve it. When I did use this string every thing worked with one exception.

"EXEC dbo.MySp @ID = 123;"

 

How do I extract the data returned from the statement?

Message 2 of 4
(3,676 Views)
Solution
Accepted by topic author JohanHoltby

To do that I only had to use Data Operation on an open statement

0 Kudos
Message 3 of 4
(3,671 Views)

Hi @ JohanHoltby

Can you provide a working sequence file example

0 Kudos
Message 4 of 4
(1,955 Views)