ID Property

后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能,并着手修改当前还在使用该功能的应用程序。

The ID property exists for Microsoft SQL Server database, agent, and replication components with defined identifiers.

语法

object
.ID

Parts

  • object
    An expression that evaluates to an object in the Applies To list

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetID(LPLONG plID);

备注

The definitions of many SQL Server database, agent, and replication components are implemented as records in SQL Server system tables. Within a system table, one column may be designated as an identifier. An identifier is a value that is unique for all rows in the table. Identifiers are assigned by SQL Server.

The ID property represents a SQL Server component identifier and, by using the ItemByID method, provides an alternate method for selecting a specific SQL Distributed Management Objects (SQL-DMO) object from its containing collection.

The ID property of the ReplicationTable2 object is designed to allow an application to retrieve a table object.

ms141883.note(zh-cn,SQL.90).gif注意:
The ID property can be retrieved using SQL Server 2005, SQL Server 2000, and SQL Server version 7.0.

Applies To:

Alert Object

MergePublication Object

Category Object

MergeSubsetFilter Object

Column Object

Operator Object

ConfigValue Object

RemoteServer Object

Database Object

ReplicationTable2 Object

DBFile Object

Rule Object

DBObject Object

StoredProcedure Object

Default Object

Table Object

DistributionArticle Object

TransArticle Object

DistributionPublication Object

TransPublication Object

FileGroup Object

Trigger Object

Index Object

User Object

Language Object

UserDefinedDatatype Object

LogFile Object

UserDefinedFunction Object

MergeArticle Object

View Object

请参阅

参考

ItemByID Method

帮助和信息

获取 SQL Server 2005 帮助