|
|
|
|
俵ÀÌ / 2001-10-25 / ¿ÀÈÄ 12:09:59 / 203.255.3.190
Á¶È¸¼ö : 117
|
[Áú¹®] ¾È³çÇϼ¼¿ä.¤Ó ³¯Â¥ ¶¡½Ã·Õ. ^^:; |
> > > ¾È³çÇϼ¼¿ä.
> > >
> > > À̹øÁÖ¿Í. ´ÙÀ½ÁÖ.. ¸¦ ±¸Çߴµ¥..
> > >
> > > ȸ¿ø¿¡¼ À̹øÁÖ »ýÀÏ ¸®½ºÆ®¿Í ´ÙÀ½ÁÖ ¸®½ºÆ®¸¦ »ÌÀ»·Á°í Çϴµ¥.. Àß ¾ÈµÇ³×¿ë.
> > >
> > >
> > > mydate=weekday(date())
> > > mysun=mydate-(mydate-1)
> > >
> > > mysun1=dateadd("d",-(mydate-1),date)
> > > myweek=mysun1+6
> > >
> > > mynextsun=myweek+1
> > > mynextweek=mynextsun+6
> > >
> > > ´ëÃæÀÌ ÀÌ·¸°Ô Çϴϱñ À̹øÁÖ¿Í ´ÙÀ½ÁÖ¸¦ ¾òÀ»¼ö ÀÖ¾ú´Âµ¥¿ä.
> > >
> > > ȸ¿øµðºñ¿¡´Â ³â,¿ù,Àϸ¦ µû·Î ÀúÀåÀ» Çߴµ¥..
> > >
> > > ¾î¶»°Ô °Ë»öÀ» ÇØ¾ß Çϳª¿ä..
> > >
> > > Á¦°¡ »ý°¢Çß´ø°ÍÀ» Çß´õ´Ï.. ÇÏÇÏ..
> > >
> > > ¸¸¾à 10¿ù´Þ¿¡ À̹øÁÖ À̸é.
> > >
> > > ´ÙÀ½ÁÖ°¡ 11¿ù´ÞÀÌ¸é ¹®Á¦°¡ µÇ´õ¶ó±¸¿ä.. ¤Ð.¤Ð;;
> > >
> > > ±×·¡¼. ÀÌ·¸°Ô ±ÛÀ» ¿Ã¸®°í ÀÖ½À´Ï´Ù.
> > >
> > > ±×·³.. À̸¸..
> > >
> > > ºü¸¥.. ´äº¯À» ºÎŹµå¸³´Ï´Ù.
> > >
> > >
> > -----------------------------------------------------------
> >
> > ÇÑÁÖ´Â ÀÏ¿äÀÏ¿¡ ½ÃÀÛÇؼ Åä¿äÀÏ¿¡ ³¡³ª´Â°Ç ¾Æ½ÇÅ×°í....
> >
> > À̹øÁÖ ÀÏ¿äÀÏÀÇ ¿ù°ú ÀÏÀ» ±¸ÇÑ´Ù
> >
> > ´ÙÀ½ÁÖ Åä¿äÀÏÀÇ ¿ù°ú ÀÏÀ» ±¸ÇÑ´Ù.
> >
> > select »ýÀÏÀλç¶÷
> >
> > from »ýÀϸñ·Ï
> >
> > where (¿ù = À̹øÁÖÀÏ¿äÀÏ¿ù AND ÀÏ>= À̹øÁÖÀÏ¿äÀÏÀÏ) OR (¿ù = ´ÙÀ½ÁÖÅä¿äÀÏ¿ù AND ÀÏ<= ´ÙÀ½ÁÖÅä¿äÀÏÀÏ)
> >
> > ÀÌ·¸°Ô ÇÏ¸é µÉ°Í °°Àºµ¥¿ä...
> >
> >
> -----------------------------------------------------------
>
> À̹øÁÖ ºÎÅÍ ´ÙÀ½ÁÖ ±îÁö °°ÀÌ °¡Á® ¿À´Â°ÍÀÌ ¾Æ´Ñ°¡¿ä??
>
> À̹øÁÖ µû·Î
> ´ÙÀ½ÁÖ µû·Î °¡Á®¿À°í ½ÍÀºµ¥
>
-----------------------------------------------------------
±×·³ select¸¦ 2¹ø ÇÏ½Ã¸é µÇÁö ¾Ê³ª¿ä?
where (¿ù = À̹øÁÖÀÏ¿äÀÏ¿ù AND ÀÏ>= À̹øÁÖÀÏ¿äÀÏÀÏ) OR (¿ù = À̹øÁÖÅä¿äÀÏ¿ù AND ÀÏ<= À̹øÁÖÅä¿äÀÏÀÏ)
where (¿ù = ´ÙÀ½ÁÖÀÏ¿äÀÏ¿ù AND ÀÏ>= ´ÙÀ½ÁÖÀÏ¿äÀÏÀÏ) OR (¿ù = ´ÙÀ½ÁÖÅä¿äÀÏ¿ù AND ÀÏ<= ´ÙÀ½ÁÖÅä¿äÀÏÀÏ)
|
|
|
|