June 10, 2011 at 1:13 pm
Hi, i am existing with below parti
Create partition function archive_dtPF(datetime)
as range right for values('20110101','20110401','20110701','20111001')...
i want to add this partition
(Create partition function archive_dtPF(varchar(50))
as range left for values ('AVMselect','RealQuest','Vector')
) to above partition.
Same partition with different data types
can i add datetime partition to varchar.
If any one that would be great.
June 10, 2011 at 1:36 pm
Forgive me if I misunderstood your question.
I havent worked on partitions for sometime but i think you should be able to use the datetime as part of the partition function as an varchar. Now should you is a different question.
June 10, 2011 at 1:48 pm
You can only have one partition function. How do you plan to relate 20110101 with AVMselect? There's no logical way to put these together and determine which values go in which partition.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply