select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='MemPointViewType'
뉴욕매니아 - 패션피플의 선택!! 글로벌쇼핑 넘버원



공지사항
상품문의
구매후기
직거래장터
select top 10 NAInc,CustKind,CustID,ServiceID,VenID,MemID,Nkind,Title,Notice,File1,File2,ClickCnt,Score,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,subject_style , subject_color ,subject_size from psNoticeAdmin where NAInc not in (select top 0 NAInc from psNoticeAdmin where 1=1 and DeleteYes=0 order by Score Desc , NAInc Desc ) and DeleteYes=0 order by Score Desc , NAInc Desc
번 호 제 목 작성일자 조회수