SQL Server标准版2008 R2与Developer Developer版2008 R2 [英] SQL server standard edition 2008 R2 vs Developer Developer edition 2008 R2

问题描述

select Hierarchy from [IMPS].[dbo].[test1] ORDER BY  CAST('/' + Hierarchy + '/' AS  HIERARCHYID) 

当我运行上面的查询它运行在

when i run above query it run in

SQL Server Developer edition 2008 R2

& on

& on

SQL server standard edition 2008 R2

它给我一个错误





类型HIERARCHYID不是定义的系统类型。





如何在

it gives me an error that


Type HIERARCHYID is not a defined system type.


how to use hierarchyid in

SQL server standard edition 2008 R2

推荐答案

尝试

Try

select CAST('/' + Hierarchy + '/' AS  HIERARCHYID) AS Hierarchy from [IMPS].[dbo].[test1] ORDER BY Hierarchy

这篇关于SQL Server标准版2008 R2与Developer Developer版2008 R2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！