Home > Merge Partitioning SQL Server 2005 > MERGE RANGE PARTITION SQL SERVER 2005

MERGE RANGE PARTITION SQL SERVER 2005

Merging Partition states moving the data into an exiting partition or to new file group (Forward only means to next file group or Partition).

 

The merged partition resides in the filegroup that originally did not hold boundary_value. boundary_value is a constant expression that can reference variables (including user-defined type variables) or functions (including user-defined functions). It cannot reference a Transact-SQL expression. boundary_value must either match or be implicitly convertible to the data type of its corresponding partitioning column, and cannot be truncated during implicit conversion in a way that the size and scale of the value does not match that of its corresponding input_parameter_type. (BOL)

 

 

Alter partition function easydb_partition_yearly_function()

merge range(‘2008-01-31 23:59:59.997’)

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: