共用方式為


SwitchPartition 方法 (Int32, Table, Int32)

Switches the specified source partition of the table to the specified target of the specified target table.

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Sub SwitchPartition ( _
    sourcePartitionNumber As Integer, _
    targetTable As Table, _
    targetPartitionNumber As Integer _
)
'用途
Dim instance As Table
Dim sourcePartitionNumber As Integer
Dim targetTable As Table
Dim targetPartitionNumber As Integer

instance.SwitchPartition(sourcePartitionNumber, _
    targetTable, targetPartitionNumber)
public void SwitchPartition(
    int sourcePartitionNumber,
    Table targetTable,
    int targetPartitionNumber
)
public:
void SwitchPartition(
    int sourcePartitionNumber, 
    Table^ targetTable, 
    int targetPartitionNumber
)
member SwitchPartition : 
        sourcePartitionNumber:int * 
        targetTable:Table * 
        targetPartitionNumber:int -> unit 
public function SwitchPartition(
    sourcePartitionNumber : int, 
    targetTable : Table, 
    targetPartitionNumber : int
)

參數

  • sourcePartitionNumber
    型別:System. . :: . .Int32
    An Int32 value that specifies the partition number of the source partition.
  • targetPartitionNumber
    型別:System. . :: . .Int32
    An Int32 value that specifies the partition number of the target partition.