다음을 통해 공유


EventChronicle.SqlStatements Property

Gets the Transact-SQL statement for an event chronicle table.

네임스페이스: 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 object containing Transact-SQL statements.

주의

Each EventChronicle must have one or more Transact-SQL statements specified using the SqlStatements property.

Use the methods of the StringCollection to add or alter the statements.

The Transact-SQL statements create the event chronicle table used to store supplemental event data. Include statements that drop or rename the event chronicle table if it already exists. If you do not drop or rename an existing event chronicle table, you will receive an "object exists" error when you update the application. You may also want to include indexing statements.

The following examples show how to define an event chronicle and add it to the collection of chronicles for an event class. The event chronicle has two Transact-SQL statements: one that adds a table that is the event chronicle and one that defines an index for the event chronicle table.

// Define a chronicle for the class
EventChronicle ec1 = 
    new EventChronicle(flightEvents, "FlightEventChonicle");
ec1.SqlStatements.Add(
    "CREATE TABLE MyAppSchema.FlightEventChronicle " + 
    " (LeavingFrom nvarchar(6), GoingTo nvarchar(6), " +  
    " Price float);");
ec1.SqlStatements.Add(
    "CREATE INDEX FlightEventChronicleIndex  " + 
    "ON MyAppSchema.FlightEventChronicle " + 
    "( LeavingFrom, GoingTo );");
flightEvents.EventChronicles.Add(ec1);
' Define a chronicle for the class.
Dim ec1 As EventChronicle = _
    New EventChronicle(flightEvents, "FlightEventChonicle")
ec1.SqlStatements.Add( _
    "CREATE TABLE MyAppSchema.FlightEventChronicle " + _
    " (LeavingFrom nvarchar(6), GoingTo nvarchar(6), " + _
    " Price float);")
ec1.SqlStatements.Add( _
    "CREATE INDEX FlightEventChronicleIndex " + _
    "ON MyAppSchema.FlightEventChronicle " + _
    "( LeavingFrom, GoingTo );")
flightEvents.EventChronicles.Add(ec1)

스레드 보안

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 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

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

관련 자료

이벤트 클래스에 대한 기록 정의
SqlSchema Element for EventClass/Chronicles/Chronicle (ADF)