The SQL Server-specific properties SQLPROP_DYNAMICSQL and SQLPROP_NESTEDQUERIES are supported by IDBProperties. These two properties are part of a SQL Server specific property set called SQLPROPSET_OPTHINTS and have defined PROPID values. The property set SQLPROPSET_OPTHINTS and the two properties are defined by using the following constants:
extern const GUID SQLPROPSET_OPTHINTS = { 0x2344480c, 0x33a7, 0x11d1, { 0x9b, 0x1a, 0x0, 0x60, 0x8, 0x26, 0x8b, 0x9e } };enum SQLPROPERTIES { SQLPROP_NESTEDQUERIES = 0x4, SQLPROP_DYNAMICSQL = 0x5 };