数据库分区函数 (sql server 2008)
你好， 我想在 sql server 2008 中为我的车队管理系统编写分区。 我想编写一个分区函数，例如 mh-30-q-126、mh-30-a-126、mh-12-fc-126 之类的值（车辆编号）应移动到相应的分区， 分别取决于中间值，例如，q，a，fc
我的试用功能：-
CREATE PARTITION FUNCTION [partition](varchar(20))
AS RANGE RIGHT
FOR VALUES ('%a%', '%G%', '%Z%')
此功能将所有（每个值）数据移动到分区 4 。
CREATE PARTITION FUNCTION [partition](varchar(20))
AS RANGE RIGHT
FOR VALUES ('a', 'G', 'Z')
这个分区不能满足我想要对中间的值进行排序的情况，例如mh-30-q-126 ..这里我想将目标值“q”移动到相应的分区,,, 请告诉我如何编写这个函数
HI,
I want to write partiton in sql server 2008 for my fleet management system.
I want to write a partition function such that --values (vehicle number) like for example mh-30-q-126,mh-30-a-126,mh-12-fc-126 should be moved to respective partiton,
depending upon middle values like ,q,a,fc respectively
My trial function:-
CREATE PARTITION FUNCTION [partition](varchar(20))
AS RANGE RIGHT
FOR VALUES ('%a%', '%G%', '%Z%')
this function moves all(every value) data to partition 4 .
CREATE PARTITION FUNCTION [partition](varchar(20))
AS RANGE RIGHT
FOR VALUES ('a', 'G', 'Z')
This partition does not satisfy me in terms where i want to sort values which are in middle eg.mh-30-q-126 ..here i want to target value "q" to move to respective partion,,,
plz tell tell me how to write this function
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您不能直接因为 PARTITION 的工作方式
“boundary_value”是一个常量，你不能使用 LIKE。
我所能建议的就是一个计算列，它可以提取您想要的值并对其进行分区。
但是，您的值可能不适合一致的解析。
注意：我没有尝试过这个。我通常会根据日期或类似的事情进行划分。
然而，除非确实有必要，否则我也不会进行分区，比如 1 亿行以上，因为分区中隐含的开销。需要分区吗？
You can't directly because of how PARTITION works
"boundary_value" is a constant and you can't use LIKE.
All I can suggest is a computed column that extracts the values you want and you partition on that.
However, you may have values which don't lend themselves to consistent parsing.
Note: I've not tried this. I'd normally partition on a date or something like that.
However, I'd also not partition unless I really had to, like 100 million rows+ because of implied overhead in partitioning. Do you need to partition?