O'Reilly logo

Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server and COM Automation

SQL Server provides a set of stored procedures that allows you to automate COM objects from Transact-SQL. Automation is a language-independent method of controlling and using COM objects. Lots of applications expose functionality via COM objects. Many of Microsoft's retail products, as well as many from other vendors, expose some type of functionality via COM objects. You can use these objects to manipulate the host application through an automation controller—a facility that knows how to interact with COM interfaces. The most popular automation controller is Visual Basic, followed closely by VBScript. SQL Server's ODSOLE facility is an automation controller in its own right and is exposed via a set of system procedures ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required