USP_SMARTFIELDPROCEDURE_GETINFORMATIONWITHSPEC

CREATE procedure dbo.USP_SMARTFIELDPROCEDURE_GETINFORMATIONWITHSPEC
(
    @ID as uniqueidentifier
)
as
    select
        SMARTFIELDCATALOG.ID as SMARTFIELDCATALOGID,
        SMARTFIELDCATALOG.DATATYPECODE as SMARTFIELDDATATYPECODE,
        SMARTFIELDCATALOG.DISPLAYNAME as SMARTFIELDDISPLAYNAME,
        SMARTFIELDCATALOG.RECORDTYPEID as SMARTFIELDRECORDTYPEID,
        [SMARTFIELDCATALOG].[VALUERECORDTYPEID] as [SMARTFIELDVALUERECORDTYPEID],
        SMARTFIELDCATALOG.HASSITEFILTER,
        SMARTFIELDCATALOG.SMARTFIELDSPECXML
    from
        dbo.SMARTFIELDCATALOG
    where
        SMARTFIELDCATALOG.ID = @ID;