SQL-DMO Syntax Conventions
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
SQL Distributed Management Objects (SQL-DMO) typographical conventions are based on those used in Microsoft Visual Basic reference materials.
Convention | Used for |
---|---|
UPPERCASE |
Transact-SQL statements, macro names, and terms used at the operating system level. |
|
Sample command lines and program code. |
placeholder |
Information that the user or the application must provide. |
object |
SQL-DMO objects; object events, methods, or properties; data types; and other syntax that must be typed exactly as shown. |
Note
Automation allows SQL-DMO to expose methods, object properties, events, and constants through intelligent and easy-to-use automation controllers, simplifying the development task.
When using an automation controller, such as Visual Basic, assistance built into the controller exposes SQL-DMO object properties, methods, and events as defined, and prompts for required or optional parameters as part of the development process. When using C or C++, every object property and method appears as an object member function, and the distinction disappears.
The SQL-DMO documentation is directed at the user of an automation controller. Properties are documented as properties, not member functions. Prototypes for SQL-DMO object member functions are included in each topic for the C or C++ developer.