ALTER TRIGGER message_Trigger1ON dbo.messageFOR INSERT /*, UPDATE, DELETE */AS /* IF UPDATE (column_name) ...*/begin declare @PhoneNum nvarchar(50) declare @Content nvarchar(140) declare @MessageId nvarchar(70) declare @index int declare @hr int declare @object int select @PhoneNum = phone_num, @Content = Content, @MessageId = message_id from inserted select @index = 1 /*调用COM发送短信*/ begin EXEC @hr = sp_OACreate '{26850DDA-862C-44FF-9232-282937F2CA4B}',@object OUT
if @hr = 0 begin exec @hr=sp_OAMethod @object,'SendMsg',NULL,@Content,@PhoneNum,@index,@MessageId exec sp_OADestroy @object end endendend红色部分中sp_OACreate中的参数是怎么来的?它跟com组件怎么联系的?具体怎么用的,谢谢
if @hr = 0 begin exec @hr=sp_OAMethod @object,'SendMsg',NULL,@Content,@PhoneNum,@index,@MessageId exec sp_OADestroy @object end endendend红色部分中sp_OACreate中的参数是怎么来的?它跟com组件怎么联系的?具体怎么用的,谢谢
你先写个 exe,功能是调用COM发短信的
然后用 EXEC 去执行这个 exe