通过

SubscriptionChronicle.SqlStatements Property

  • 项目

Gets the collection of Transact-SQL statements that create the subscription chronicle.

命名空间: Microsoft.SqlServer.Management.Nmo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public ReadOnly Property SqlStatements As StringCollection

public StringCollection SqlStatements { get; }

public:
property StringCollection^ SqlStatements {
    StringCollection^ get ();
}

/** @property */
public StringCollection get_SqlStatements ()

public function get SqlStatements () : StringCollection

属性值

A StringCollection containing the Transact-SQL statement strings.

备注

Use the StringCollection methods to add or modify the statements that create the subscription chronicle.

When using a subscription chronicle, you should drop or rename the chronicle table if it already exists and then create the chronicle table. If you do not drop or rename an existing chronicle table, you receive an "object exists" error when you update the application.

示例

The following examples show how to create a subscription chronicle:

// Define a chronicle for the subscription class
SubscriptionChronicle sc1 = new SubscriptionChronicle(
    flightSubscriptions, "FlightSubChronicle");
sc1.SqlStatements.Add(
    "CREATE TABLE MyAppSchema.FlightSubChronicle " + 
    " (SubscriptionId bigint, LeavingFrom nvarchar(6), " + 
    "  GoingTo nvarchar(6), Price float);");
sc1.SqlStatements.Add(
    "CREATE INDEX FlightSubChronicleIndex  " +
    " ON MyAppSchema.FlightSubChronicle " +
    " ( LeavingFrom, GoingTo );");
flightSubscriptions.SubscriptionChronicles.Add(sc1);

' Define a chronicle for the subscription class
Dim sc1 As SubscriptionChronicle = New SubscriptionChronicle( _
    flightSubscriptions, "FlightSubChronicle")
sc1.SqlStatements.Add( _
    "CREATE TABLE MyAppSchema.FlightSubChronicle " + _
    "(SubscriptionId bigint, LeavingFrom nvarchar(6), " + _
    "GoingTo nvarchar(6), Price float);")
sc1.SqlStatements.Add( _
    "CREATE INDEX FlightSubChronicleIndex  " + _
    "ON MyAppSchema.FlightSubChronicle " + _
    "( LeavingFrom, GoingTo );")
flightSubscriptions.SubscriptionChronicles.Add(sc1)

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

SubscriptionChronicle Class
SubscriptionChronicle Members
Microsoft.SqlServer.Management.Nmo Namespace

其他资源

为订阅类定义历史记录
SqlSchema Element for SubscriptionClass/Chronicles/Chronicle (ADF)