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

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/