What are the challenges you face when working across database platforms? Take the survey
Options

Incorrect usage of UDF IsDescendantOf

Andy_HAndy_H Posts: 1 New member
DECLARE @Parent HIERARCHYID = '/'

SELECT *
FROM Customers_Hierarchy
WHERE CustomerHierarchy.IsDescendantOf(@Parent) = 1

Hi,

I'm trying to understand the SQL Prompt warning which says this is an incorrect usage of const UDF.
Tagged:

Answers

Sign In or Register to comment.