cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to Create a Stored Procedure from thingworx service

SOLVED
Highlighted
Regular Member

How to Create a Stored Procedure from thingworx service

I want to create a stored procedure from thingworx service, when I'm run test it throw an error 

"Unable to Invoke Service ListServices on  TestDatabase: Incorrect syntax near 'GO'. "

for example:

USE [SERVICE1]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
CREATE PROCEDURE [dbo].[ListServices]
@product_id nvarchar(32)
AS
BEGIN
.........
END
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: How to Create a Stored Procedure from thingworx service

Hi @vxba could you try something like this :

 

Create procedure dbo.demoProc1
@Sno int
AS
SET NOCOUNT ON;
Select * from table1
where sNO = @Sno;

Let me know if there's any issue.

View solution in original post

2 REPLIES 2
Highlighted

Re: How to Create a Stored Procedure from thingworx service

Hi @vxba could you try something like this :

 

Create procedure dbo.demoProc1
@Sno int
AS
SET NOCOUNT ON;
Select * from table1
where sNO = @Sno;

Let me know if there's any issue.

View solution in original post

Highlighted

Re: How to Create a Stored Procedure from thingworx service

Thank you! It worked for me

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!