vbÓÐÀàËÆsql inµÄ¹¦ÄÜÂð£¿
SQLÖв»ÊÇÓиöÅжÏij¸ö×Ö¶Îinij¸ö·¶Î§µÄ¹¦ÄÜ£¬ÎÒÏëÎÊvbÀïÃæÓÐûÓÐÕâ¸ö¹¦ÄÜ£¿
case select
²»Òªselect case
×Ô¼ºÐ´¸öº¯ÊýµÃÁË,±È½Ï¼òµ¥
Ïñ²é±í·¨Ó¦¸Ã¿ÉÒÔʵÏÖÕâ¸ö¡£²»¹ýÎÒÖ»ÔÚCRCУÑéÖп´µ½¹ý
½ÅÍ´Ò½½Å¡£
¼¦Í¬Ñ¼½²¡£
Èç¹ûÊÇ×Ö·û´®µÄin,¿ÉÒÔ¿¼ÂÇʹÓÃfilterº¯Êý
ÆäËûµÄ¿ÉÒÔ¿¼ÂÇswitchº¯Êý
ûÓÐÕæÕýÀàËÆµÄ
Ò²¿ÉÒÔ¿¼ÂÇʹÓÃlike
ÔÚVBÀï¿ÉÒÔÖ±½Óµ÷ÓÃSQLÓï¾ä¡£
²»·Á°ÑÄãÏë×öµÄÊÂÇé˵µÄ¸ü¾ßÌåЩ£¬´ó¼Ò²ÅºÃ°ïÄã³öÖ÷Òâ
Â¥Ö÷˵µÄ¹¦ÄÜÀàËÆÓÚ¼¯ºÏ²Ù×÷£¬VBÖв»Ö§³Ö¡£
²»¹ý£¬Äã¿ÉÒÔʹÓÃÆäËû·½·¨À´ÊµÏÖÏà½üµÄ¹¦ÄÜ£¬Õâ¾ÍµÄ¾ßÌåÎÊÌâ¾ßÌå·ÖÎöÁË¡£²»ÖªÂ¥Ö÷¾ßÌåÏë×öʲô£¿
Çé¿öÊÇÕâÑù£¬²»ÊǾ³£ÒªÅжÏif x=b or x=y or x=z then ÕâÑùµÄÌõ¼þÂð¡£ÎÒÏë¿É·ñÀàËÆSQLÖÐµÄ where x in('b','y','z')£¬²»ÓÃдÄÇô¶àorÁË¡£
¿ÉÒÔ×Ô¼ºÐ´º¯Êý£¬±ÈÈ磺
VB code:
Function Include(sou, ParamArray arrFind()) As Boolean
Dim arr
For Each arr In arrFind
If sou = arr Then
Include = True
End If
Ne
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
Ϊʲô¹¤¾ßÀ¸°´Å¤µÄ¿í¶È¸Ä±ä²»ÁË,ÔÚÊôÐÔÀï¸ÄÁËÓÖ±ä³ÉÔÀ´µÄÊýÖµÁË
´óºú×ÓÕæÀ÷º¦£¬»Ø´ð»ù±¾¶¼ÊDZ¬Áϼ¶µÄ
´óºú×ÓÉý¼¶Õæ¿ì°¡£¬Õâ²Å¼¸Ìì¾Í5Ìõ¶Ì¿ãÍâ¼ÓÔÂÅÅÃûµÚÒ»ÁË
ÏëÏëÎÒÕâ5¸ö¶Ì¿ã»ìÁ˲¶à8Äê²ÅµÃµ½µÄ¡£
»Ø¸´ ......
sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔÎ µ ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......