设置枚举字段,要选择枚举类型,系统内已有大量的枚举,但是只能一个一个查看,做了一个sql,可以搜索自己的枚举值系统内是否有,合适的话就不用新建了.

修改search的值就行.比如枚举项:市内.

 declare @search nvarchar(100);

set @search='市内'

SELECT mjlx.FNAME 枚举类型 ,b.FCAPTION AS 枚举名称,a.FVALUE AS 枚举值 ,a.FENUMID AS 枚举内码,a.fid ,* FROM T_META_FORMENUMITEM a

LEFT JOIN T_META_FORMENUMITEM_L b ON a.FENUMID=b.FENUMID AND b.FLOCALEID=2052

left join T_META_FORMENUM_L mjlx on mjlx.fid=a.fid and mjlx.FLOCALEID=2052

WHERE a.FID in (SELECT fid FROM T_META_FORMENUMITEM a

LEFT JOIN T_META_FORMENUMITEM_L b ON a.FENUMID=b.FENUMID AND b.FLOCALEID=2052

where b.FCAPTION like @search)

ORDER BY a.fid,a.FSEQ