[dbo].[CollectionFirst]

(local) > mdb > Scalar-valued Functions > dbo.CollectionFirst

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@x	xml	max

SQL Script

CREATE FUNCTION [dbo].[CollectionFirst](@x XML) returns int
BEGIN
return(
SELECT MIN(T.c.value('@key', 'int'))
FROM @x.nodes('collection/item') T(c)
)
END;
GO

Uses

dbo
[T].[c].[value]