如何将流分析输出设置为存储过程 [英] How can I set Stream Analytics Output as Stored Procedure

问题描述

如何添加存储过程作为分析输出更简单地如何将我的分析结果发送到 sp 参数

How can I add Stored Procedure as Analytics Output More simply how can I send my analytics result to sp parameter

推荐答案

如何将我的分析结果发送到 sp 参数

how can I send my analytics result to sp parameter

如果您想将流分析作业结果传递给 SQL 数据库中的存储过程，似乎没有直接的方法将分析结果传递给存储过程并执行存储过程.

If you’d like to pass Stream Analytics jobs result to a Stored Procedure in SQL Database, it seems that there are no direct way to pass analytics result to Stored Procedure and execute the Stored Procedure.

流分析作业可以将结果写入 Azure SQL 数据库中的现有表，您可以尝试创建一个 触发并从表中查询结果并使用分析结果执行存储过程，这可能是一个可能的解决方案.

Stream Analytics jobs could write result to an existing table in an Azure SQL Database, you could try to create a Trigger and query result from table and execute Stored Procedure with analytics result, which might be a possible solution.

CREATE TRIGGER mytesttrigger  
ON [dbo].[TableName]
AFTER INSERT   
AS  
   --query the result 

   --execute SP

   EXEC [dbo].[SP name] @para1 = 'val1', @para2 = 'val2';
GO

这篇关于如何将流分析输出设置为存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！