我有一个已添加到Azure SQL Server的存储过程。每次我通过Azure Logic App或在SSMS中执行该过程时,当我查看正在运行的查询时都会执行创建。
这正常吗?
存储过程
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [FHQGY].[getcommentsToEventServiceBus]
AS
BEGIN
SET NOCOUNT ON
DeclARE @Results TABLE
(
CommentId INT NOT NULL,CallId VARCHAR(8) NOT NULL,Jsonmessage VARCHAR(1500) NOT NULL
)
INSERT INTO @Results (CommentId,CallId,Jsonmessage)
SELECT TOP(500)
comments.COMMENT_ID,comments.CALL_ID,concat('{','"event":"commentadded"',','"callId":"',calls.CALL_ID,'"','"commentId":',comments.COMMENT_ID,'"testCall":',(CASE WHEN calls.TEST_flaG = 'Y' THEN 'true' ELSE 'false' END),'"useProd":',(CASE WHEN DB_NAME() = 'ProdDB' THEN 'true' ELSE 'false' END),'"submittedDateTime":"',FORMAT(dbo.GetDateCDT(GETUTCDATE()),'yyyy-MM-ddTHH:mmZ'),'"overrideEmailaddress":""','}')
FROM
FHQGY.AD_CC_CALL_COMMENTS comments
JOIN
FHQGY.AD_CC_CALLS calls ON comments.CALL_ID = calls.CALL_ID
WHERE
1 = 1
AND (comments.SENT_TO_EVENT_BUS = 0 OR comments.SENT_TO_EVENT_BUS IS NULL)
ORDER BY
comments.ADD_TSTAMP ASC
SELECT DISTINCT
CommentId,Jsonmessage
FROM
@Results
END