Type Property (StoredProcedure)
The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ 2000 component.
Applies To
StoredProcedure Object |
Syntax
object.Type [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
Long integer that controls interpretation of SQL Server stored procedure text as described in Settings
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetType(SQLDMO_PROCEDURE_TYPE* pRetVal)
HRESULT SetType(SQLDMO_PROCEDURE_TYPE NewValue)
Settings
Constant | Value | Description |
---|---|---|
SQLDMOProc_Extended | 2 | StoredProcedure object references an extended stored procedure. |
SQLDMOProc_Macro | 3 | Reserved for future use. |
SQLDMOProc_ReplicationFilter | 4 | Reserved for future use. |
SQLDMOProc_Standard | 1 | Default. StoredProcedure object references a SQL Server stored procedure. |
SQLDMOProc_Unknown | 0 | Bad or invalid value. |
Remarks
When using the StoredProcedure object to create a SQL Server stored procedure, setting the Name, Type, and Text properties define the stored procedure. By default, the text of a stored procedure is interpreted as a Transact-SQL script. When the stored procedure is an entry point for an extended stored procedure, the text of the procedure specifies an executable-image library by name.