==검색 쿼리
select member_id from member where member_id like '%a%'

select count(member_id) as 'total'  from member where member_id like '%a%'

select c.config_nick,c.config_title,c.config_intro,w.member_id,w.writing_title,w.writing_content
from config as c, writing as w
where c.config_nick like '%a%' or c.config_title  like '%a%' or c.config_intro  like '%a%' or w.member_id  like '%a%' or w.writing_title  like '%a%' or w.writing_content  like '%a%'

select count(w.member_id) as 'total'
from config as c, writing as w
where c.config_nick like '%a%' or c.config_title  like '%a%' or c.config_intro  like '%a%' or w.member_id  like '%a%' or w.writing_title  like '%a%' or w.writing_content  like '%a%'

==덧글 쿼리

select count(*)
from writing as w inner join reply as r
on w.writing_sn = r.writing_sn
group by r.writing_sn

select distinct r.writing_sn, w.writing_title, count(*) as total
from reply as r, writing as w
where  w.writing_sn = r.writing_sn
group by r.writing_sn,w.writing_title
order by total desc

select distinct top 3 r.writing_sn, w.writing_title, count(*) as total
from reply as r, writing as w
where  w.writing_sn = r.writing_sn
group by r.writing_sn,w.writing_title
order by total desc

==오늘의 미니홈피 쿼리
select top 1 c.member_id, s.sub_category_name, s.sub_category_sn, w.writing_content, c.config_image
from today as t join config as c
on t.member_id = c.member_id
join sub_category as s
on s.member_id=c.member_id

==mdf ldf로 복원하는 방법
EXEC sp_attach_db 'pubs'
, 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
, 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'
 join writing as w
 on s.sub_category_sn = w.sub_category_sn
order by today_date desc, w.writing_date desc