Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Beginner
Jul 2, 1998

SQL Feature to Integrate with COM Objects

SQL Server has a very powerful, but often overlooked, feature to integrate with COM objects. SQL itself can create COM objects from within Triggers or Stored Procedures, apply property values and execute methods. What you commonly see in Visual Basic, and other languages, that looks similar to:
 
Set oFoo = CreateObject("Foo.cFoo")
oFoo.Condition = "Quantity Low"
oFoo.Responsible = "Joe Karbowski"
oFoo.SendPagerMsg
Set oFoo = Nothing
you can also do in SQL Server T-SQL sp_OA calls. This is especially useful if you need to take action that isn't necessarily associated with a database, like dialing a pager or integrating to custom middleware. The power comes in the reuse of you COM components and enforcing a single set of business rules.
Joe Karbowski
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date