UFN_SQLSTOREDPROCEDURE_GETSMARTFIELDDEFINITION

create function dbo.UFN_SQLSTOREDPROCEDURE_GETSMARTFIELDDEFINITION()
returns xml
as
begin
return
(
    select 
        SMARTFIELDCATALOG.ID,
        SMARTFIELDCATALOG.FORMMETADATAXML,
        SMARTFIELDCATALOG.DATATYPECODE,
        SMARTFIELDCATALOG.RECORDTYPEID,
        SMARTFIELDCATALOG.DISPLAYNAME
    from 
        dbo.SMARTFIELDCATALOG                    
    where                         
        SMARTFIELDCATALOG.DATATYPECODE is not null
    order by
        SMARTFIELDCATALOG.DISPLAYNAME
    for xml raw('ITEM'),type,elements,root('SMARTFIELDDEFINITIONS'),BINARY BASE64
)
end