Code:
USE RADAR
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'mailreminder' AND type = 'TR')
DROP TRIGGER mailreminder
GO
CREATE TRIGGER mailreminder
ON ChartType
FOR INSERT
AS
Declare @Object as Int;
Declare @ResponseText as Varchar(8000);
Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;
Exec sp_OAMethod @Object, 'open', NULL, 'get',
'http://localhost:52055/RadarCS...l.asmx/InsertMail?incomin=MSFT' ,
'false'
Exec sp_OAMethod @Object, 'send'
Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT
Select @ResponseText
Exec sp_OADestroy @Object
GO
USE RADAR
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'mailreminder' AND type = 'TR')
DROP TRIGGER mailreminder
GO
CREATE TRIGGER mailreminder
ON ChartType
FOR INSERT
AS
Declare @Object as Int;
Declare @ResponseText as Varchar(8000);
Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;
Exec sp_OAMethod @Object, 'open', NULL, 'get',
'http://localhost:52055/RadarCS...l.asmx/InsertMail?incomin=MSFT' ,
'false'
Exec sp_OAMethod @Object, 'send'
Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT
Select @ResponseText
Exec sp_OADestroy @Object
GO
U trinestom redu umesto hard coded MSFT treba da posaljem to sto mi triger vrati. Znaci 13ti red bi izgledao kao:
'http://localhost:52055/RadarCS...dMail.asmx/InsertMail?incomin=' + ChartType.Type
ali mi javlja
Msg 102, Level 15, State 1, Procedure mailreminder, Line 10
Incorrect syntax near '+'.
Help...
Potpis
To sto nekoliko miliona ljudi tvrdi da nisi u pravu ne znaci da stvarno nisi - Frank Zappa
https://youtu.be/DLe358DPGXU
https://youtu.be/DLe358DPGXU