UFN_MAPPEDVALUES_GETERRORMESSAGE
Extracts ErrorMessage from xml field
Return
| Return Type |
|---|
| varchar(4000) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MAPPEDVALUES | xml | IN |
Definition
Copy
create function dbo.UFN_MAPPEDVALUES_GETERRORMESSAGE(@MAPPEDVALUES xml)
returns varchar(4000)
with execute as caller
as begin
return (select T.c.value('(ERRORMESSAGE)[1]','varchar(max)') from @MAPPEDVALUES.nodes('/MAPPEDVALUES/ROW') T(c))
end