钉钉机器人SQL存储直接调用发送消息.txt

CREATE            PROCEDURE [dbo].[XXXX]
/**
--1 启用 Ole Automation Procedures 选项
exec sp_configure 'show advanced options',1;
go
reconfigure;
go
sp_configure 'Ole Automation Procedures',1;
go
reconfigure;
go
*/

    
as
declare @url  VARCHAR(200),    --钉钉机器人Webhook 地址
        @data nVARCHAR(max),   --内容
        @text VARCHAR(max),    --未知 
        @title varchar(20),     --通知抬头 
        @info varchar(8000)
        

set @url = N'https://oapi.dingtalk.com/robot/send?access_token=机器人'



IF exists(select 
 XXX
from XXX)
begin