Article - CS256389

How to return the output of a Stored Procedure in ThingWorx in a Service

Modified: 19-Apr-2021   


Applies To

  • ThingWorx Platform 7.2 F000 to 8.5 SP13

Description

  • How do I return the output of a Stored Procedure in Microsoft SQL Server to a service in ThingWorx
  • Can a service invoke a Stored Procedure to both insert data in a relational database and also read the last inserted value
  • An SQL Command only returns a success or failure result, but we need the output of a Stored Procedure
This is a printer-friendly version of Article 256389 and may be out of date. For the latest version click CS256389