UFN_GETAUDITDETAILXML
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @AUDITTABLE | nvarchar(128) | IN | |
| @AUDITKEY | uniqueidentifier | IN | |
| @RECORDID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_GETAUDITDETAILXML(@AUDITTABLE nvarchar(128), @AUDITKEY uniqueidentifier, @RECORDID uniqueidentifier) returns xml
as
begin
declare @x xml
set @x=(select FIELD, OLD, NEW from dbo.UFN_GETAUDITDETAIL(@AUDITTABLE, @AUDITKEY, @RECORDID) for xml raw('CHANGE'), ELEMENTS, BINARY BASE64, TYPE, ROOT('DETAILS'))
return @x
end