How to call a scalar function in a stored procedure

Question

I am wacking y head over the problem with this code.

DECLARE @root hierarchyid
declare @lastchild hierarchyid
SELECT @root = NodeHierarchyID from NodeHierarchy where ID = 1
set @lastchild = getlastchild(@root)

it says it does not recognize getlastchild function. What am I doing wrong here

Answer 1

try including the schema id, as in @lastchild = dbo.getlastchild(@root).

Answer 2

Try

set @lastchild = dbo.getlastchild(@root)

Answer 3

Use

set @lastchild = dbo.getlastchild(@root)

From CREATE FUNCTION

Scalar-valued functions may be invoked where scalar expressions are used, including computed columns and CHECK constraint definitions. When invoking scalar-valued functions, at minimum use the two-part name of the function.