.
1. ¸ÞÀÎ »èÁ¦ÀÛ¾÷
Delete from PanChitYyMm Where PctDay=ÀÏÀÚ
Delete from PanGodsYyMm Where PcgDay=ÀÏÀÚ
Delete from PanListYyMm Where PclDay=ÀÏÀÚ
Delete from PanCardYyMm Where PcdDay=ÀÏÀÚ
.
2. °è»ê´ë Æ÷½ºº° °¢°¢ Àü¼ÛÀÛ¾÷
Áߺ¹ Àü¼Û ±ÝÁö
.
3. ¸ÞÀÎ ÀüÇ¥¹ß»ý¿Ï·á ¼³Á¤ÀÛ¾÷
Update PanChitYyMm Set PctJunsong=2 Where PctDay=ÀÏÀÚ
ÀüÇ¥¹ß»ý°¡´É¼³Á¤Àº PctJunsong=1
.
|