4/13/2010

자바스크립트_달력소스

<html>

<head>
<meta http-equiv="content-type" content="text/html; charset=euc-kr">
<title>달력 스크립트</title>
<meta name="generator" content="Microsoft FrontPage 4.0">
<style>
td {text-decoration:none; }
font {text-decoration:none; line-height:130%;}
A:link,A:active,A:visited{text-decoration:none;color:'#333333';}
A:hover {text-decoration:none; color:'ff9900'}
</style>
<link rel="STYLESHEET" type="text/css" href="board_style.css">
<SCRIPT LANGUAGE="JavaScript">
<!--
    var monthName=new Array("1월","2월","3월","4월","5월","6월","7월",
    "8월","9월","10월","11월","12월")
    var monthDays=new Array(31,28,31,30,31,30,31,31,30,31,30,31)
    var now=new Date
    var nowd=now.getDate()
    var nowm=now.getMonth()
    var nowy=now.getYear()
    function showCalendar(day,month,year)
    {
  if ((year%4==0||year%100==0)&&(year%400==0)) monthDays[1]=29; else monthDays[1]=28 //leap year test
  var firstDay=new Date(year,month,1).getDay()
  var calStr="<table border=0 cellpadding=5 cellspacing=1 align=center bgcolor=#CCCCCC>"

  calStr+="<tr bgcolor=white><td colspan=7>"

  calStr+="<table border=0 cellpadding=0 cellspacing=0 align=center width=100%>"
  calStr+="<td><font size='2'><a href='javascript:;' onClick='nowm--; if (nowm<0) { nowy--; nowm=11; } showCalendar(nowd,nowm,nowy)' title='이전 월'> <<</a></font></td>"
  calStr+="<td align=center><font size='2'>"+monthName[month].toUpperCase()+" "+year+"년</font></td>"
  calStr+="<td align=right><font size='2'><a href='javascript:;'  onClick='nowm++; if (nowm>11) { nowy++; nowm=0; } showCalendar(nowd,nowm,nowy)' title='다음 월'> >></a></font></td>"
  calStr+="</tr></table>"

  calStr+="</td></tr>" 

  calStr+="<tr align=center bgcolor='#336666'>"
  calStr+="<th><font color='red' size='2'>일</font></th>"
  calStr+="<th><font color='white' size='2'>월</font></th>"
  calStr+="<th><font color='white' size='2'>화</font></th>"
  calStr+="<th><font color='white' size='2'>수</font></th>"
  calStr+="<th><font color='white' size='2'>목</font></th>"
  calStr+="<th><font color='white' size='2'>금</font></th>"
  calStr+="<th><font color='#66CCFF' size='2'>토</font></th>"
  calStr+="</tr>" 

  var dayCount=1

  calStr+="<tr bgcolor=white>"

  for (var i=0;i<firstDay;i++) calStr+="<td> "  //공백
  for (var i=0;i<monthDays[month];i++)
  {



  if(dayCount==nowd) {
  calStr+="<td align=center bgcolor='#DFE7DE'><font size='2'><b>" // 오늘 날짜일때 배경색 지정,글자 진하게

  } else {

  calStr+="<td align=center><font size='2'>"  // 오늘 날짜가 아닐때 배경색 지정
  }

  calStr+="<a href='http://haxim.kr'>" // 링크설정

  calStr+=dayCount++  // 날짜
 
  calStr+="</a>"

  if(dayCount==nowd) {

  calStr+="</b>" // 오늘 날짜일때 글자 진하게

  } else {

  calStr+=""  // 오늘 날짜가 글자 진하게 안함
  }
        calStr+="</font>"
  if ((i+firstDay+1)%7==0&&(dayCount<monthDays[month]+1)) calStr+="<tr bgcolor=white>"
  }
  var totCells=firstDay+monthDays[month]
  for (var i=0;i<(totCells>28?(totCells>35?42:35):28)-totCells;i++) calStr+="<td> "
  calStr+="</table><BR>"
  calendar.innerHTML=calStr
    }
//-->
</SCRIPT>
</head>

<body>
<SPAN ID=calendar STYLE="position:relative;"></SPAN>
<script language="JavaScript" type="text/JavaScript">
showCalendar(nowd,nowm,nowy);
</script>

</body>

</html>

펌..

4/12/2010

mssql 테이블정보보기

-- 테이블 리스트
select * from information_schema.tables

-- 컬럼 상세 정보
select * from information_schema.columns
where table_name = '테이블명'
order by 5