Export (0) Print
Expand All

SQL-DMO Syntax Conventions

This feature will be removed in the next 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.

code

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.

NoteNote

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.

Community Additions

ADD
Show:
© 2015 Microsoft