이리의 공간

텔레그램 봇이 먼저 동작하고 있어야 합니다. DECLARE @obj int , @response nvarchar(4000) , @url VARCHAR(MAX) = 'https://api.telegram.org/bot' , @bot_id VARCHAR(MAX) = '텔레그램 bot id' , @chat_id VARCHAR(MAX) = '텔레그램 chat id' SET @url = @url + @bot_id + '/sendmessage?chat_id=' + @chat_id + '&text=' DECLARE @M VARCHAR(MAX) = '' , @L INT = 0 , @I INT = 1 , @C VARCHAR(MAX) = '' SET @M = CONVERT(VARCHAR(MAX), master.dbo.To..

/* exec sp_configure 'show advanced options', 1; go reconfigure; go exec sp_configure 'Ole Automation Procedures', 1; go reconfigure; go */ declare @obj int , @response nvarchar(4000) exec sp_OACreate 'MSXML2.XMLHTTP', @obj out; exec sp_OAMethod @obj, 'open', NULL, 'get', 'https://호출할 API 주소', 'false' exec sp_OAMethod @obj, 'send' exec sp_OAMethod @obj, 'responseText', @response output select @r..