¹ØÓÚaspÖÐifÖ´ÐÐЧÂʵÄÎÊÌâ

Èç¹û¸ù¾ÝÒ»¸öÌõ¼þÀ´Ö´Ðв»Í¬µÄsqlÓï¾ä£¬È磺

if str="a" then
  sql="select xxx from [tab] where xxx"
elseif str="b" then
  sql="select xxx from [tab] where xxx"
elseif str="c" then
  sql="select xxx from [tab] where xxx"
elseif str="d" then
  sql="select xxx from [tab] where xxx"
¡­¡­
end if


Èç¹ûÕâÀïÃæÓкܶàµÄif elseif £¬ÔÚ²éѯ±È½ÏƵ·±µÄʱºò£¬ÈçºÜ¶à¿Í»§¶ËÔÚÏßͬʱ²éѯµÄʱºò£¬»áÑÏÖØÓ°ÏìÖ´ÐÐЧÂÊÂð£¿

Èç¹û²»ÓÃif£¬ÊÇ·ñÓкõĽâ¾ö·½·¨ÄØ£¿

---

ÓÃswitch case

---

»¹ÓоÍÊÇifÌõ¼þ£¬Ê¹ÓÃÖÐÎÄ×Ö·ûµÄÌõ¼þ»á±ÈʹÓÃÓ¢ÎÄ»òÕßÊý×ÖµÄÀ´µÃÂýÂð£¿
±ÈÈç
if str="Öйú" ÕâÑù£¬»¹ÊÇif str="CN"»òif str="086" ÕâÑù¿ì£¿»¹ÊDz¶à£¿

---

aspÖкÃÏñûÓÐswitch case£¿Ó¦¸ÃÊÇselect case°É£¿

select caseЧÂʱÈif elseif¸ßÂð£¿

---

Select Case½á¹¹Ö»¼ÆË㿪ʼ´¦µÄÒ»¸ö±í´ïʽ£¨Ö»¼ÆËãÒ»´Î£©£¬¶ø If...Then...ElseIf ½á¹¹¼ÆËãÿ¸ö ElseIf Óï¾äµÄ±í´ïʽ£¬ÕâЩ±í´ïʽ¿ÉÒÔ¸÷²»Ïàͬ¡£½öµ±Ã¿¸ö ElseIf Óï¾ä¼ÆËãµÄ±í´ïʽ¶¼Ïàͬʱ£¬²Å¿ÉÒÔʹÓà Select Case ½á¹¹´úÌæ If...Then...ElseIf ½á¹¹¡£

---

¸öÈËÈÏΪÕâ¸öÔì³ÉµÄЧÂÊÎÊÌâ¿ÉÒÔºöÂÔ²»¼Æ¡£

---

ÒýÓÃ

Èç¹û¸ù¾ÝÒ»¸öÌõ¼þÀ´Ö´Ðв»Í¬µÄsqlÓï¾ä£¬È磺

if str="a" then
  sql="select xxx from [tab] where xxx"
elseif str="b"