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 endend红色的部分不知道sp_OACreate中的参数是怎么来的,跟com组件中的dll又有什么联系,
if @hr = 0 begin exec @hr=sp_OAMethod @object,'SendMsg',NULL,@Content,@PhoneNum,@index,@MessageId
exec sp_OADestroy @object end endend红色的部分不知道sp_OACreate中的参数是怎么来的,跟com组件中的dll又有什么联系,
或直接在注册表里查找