Refresh Method
Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
The Refresh method updates a SQL Distributed Management Objects (SQL-DMO) object or collection with current values from the referenced instance of Microsoft SQL Server.
Syntax
object
.Refresh( [ Release ] )
Parts
object
Expression that evaluates to an object in the Applies To list.Release
TRUE or FALSE as described in Settings.
Prototype (C/C++)
HRESULT Refresh(BOOL bReleaseMemberObjects = FALSE);
Settings
When Release is TRUE, all references maintained on a collection member, and any collections or objects within the member's tree, are released by force by SQL-DMO. SQL-DMO objects used by the application are invalid. SQL-DMO retrieves member object property values and refreshes the member object collection on the next application access to the object.
When Release is FALSE (default), application-maintained references are released only when the reference is on an object exposing a deleted or removed SQL Server component. Accessing a member object does not refresh member property values or contained collections.
Hinweise
Use caution when using the Refresh method. In general, it is best to override the default value for the Release argument, as forcing reference release ensures that all objects within a hierarchy represent the current state of an instance of SQL Server.
Limit the scope of the Refresh method to optimize its execution. For example, use the Refresh method of a Table object to update the application image of properties of a specific SQL Server table when applicable, rather than using the Refresh method of Tables collection indiscriminately.
Applies To:
Columns Collection |
|
|