memberList

create proc memberList
as
begin
 select
  mName+'('+mNickName+')' as mName,
  mID,
  left(mBirthday,4) +'년' + substring(mBirthday,6,2) + '월' + right(mBirthday, 2) + '일' as mBirthday,
  convert(char(16), mRegDate, 120) as mRegDate,
  mVisit,
  ERC_DB.dbo.YorN(mMailling) as mMailling
  from member order by mRegDate desc
end