question

MrParkin avatar image
MrParkin asked

Send query result to c# program if record value = X

We use an interface (programmed in c++) which creates a MSSQL Databse. I want to use this data in my own application, but want SQL Server to send it.

When a values in a specific record of a row in a table gets Created, I want to run a stored procedure and send the results back to my C# program, which will then decide what to do with that data

stored procedurestriggersmanagement-studiomssql2012
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
erlokeshsharma08 avatar image
erlokeshsharma08 answered

On high level - You can use after triggers to accomplish this task.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.