开发者

T-SQL - create partition function and scheme - SQL Server 2008

开发者 https://www.devze.com 2022-12-09 02:20 出处:网络
I am creating partition function and schemes. In SQL Server 2008, it only defines range partitioning and not list partitions.

I am creating partition function and schemes.

In SQL Server 2008, it only defines range partitioning and not list partitions.

Dont we have list partitioning in SQL Server?

I am using SQL Server 开发者_如何学JAVA2008 Enterprise edition.


There is no List Partitioning in SQL Server 2008. But you can fake it into creating one using the LEFT clause.

Read up here:

http://www.sqlservercentral.com/articles/partition/64740/

0

精彩评论

暂无评论...
验证码 换一张
取 消