次の方法で共有


Add (clsCollection)

ms135634.note(ja-jp,SQL.90).gifメモ :
  この機能は、Microsoft SQL Server の次のバージョンで削除されます。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションはできるだけ早く修正してください。

The Add method of a Decision Support Objects (DSO) collection adds an object to the collection. This method does not apply to CustomProperties collections.

ms135634.note(ja-jp,SQL.90).gifメモ :
  It is recommended that you use the AddNew method when adding new objects. You should use the Add method only when adding existing objects: for example, when you are adding aggregations to a partition after you have designed them. For more information, see clsPartitionAnalyzer.

構文

object.Add(obj, [sKey As String], [Before])

パラメータ

  • object
    An instance of a DSO collection object.
  • obj
    An instance of a DSO object.
  • sKey
    (Reserved) Defaults to Item.Name. If specified, it must contain the value of the item's Name property.
  • Before
    (Optional) An expression that specifies a relative position in the collection. The member to be added is placed in the collection before the member identified by the Before argument. The value of Before must be a number from 1 to the value of the colCollection.Count property. If you omit this parameter, the item is appended at the last position in the collection. This argument is ignored if the collection is sorted; the member to be added is placed in the position indicated by the sort order of the collection.

    ms135634.note(ja-jp,SQL.90).gifメモ :
      All collections in the DSO object model are one-based. That is, the first item in the collection has an index of 1 and the last item has an index equal to the value of the Count property.

参照

その他の技術情報

Collections

ヘルプおよび情報

SQL Server 2005 の参考資料の入手