Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

vbÓÐÀàËÆsql inµÄ¹¦ÄÜÂð£¿

SQLÖв»ÊÇÓиöÅжÏij¸ö×Ö¶Îinij¸ö·¶Î§µÄ¹¦ÄÜ£¬ÎÒÏëÎÊvbÀïÃæÓÐûÓÐÕâ¸ö¹¦ÄÜ£¿
case select

²»Òªselect case

×Ô¼ºÐ´¸öº¯ÊýµÃÁË,±È½Ï¼òµ¥

Ïñ²é±í·¨Ó¦¸Ã¿ÉÒÔʵÏÖÕâ¸ö¡£²»¹ýÎÒÖ»ÔÚCRCУÑéÖп´µ½¹ý

½ÅÍ´Ò½½Å¡£
¼¦Í¬Ñ¼½²¡£

Èç¹ûÊÇ×Ö·û´®µÄin,¿ÉÒÔ¿¼ÂÇʹÓÃfilterº¯Êý
ÆäËûµÄ¿ÉÒÔ¿¼ÂÇswitchº¯Êý
ûÓÐÕæÕýÀàËÆµÄ

Ò²¿ÉÒÔ¿¼ÂÇʹÓÃlike

ÒýÓÃ
SQLÖв»ÊÇÓиöÅжÏij¸ö×Ö¶Îinij¸ö·¶Î§µÄ¹¦ÄÜ£¬ÎÒÏëÎÊvbÀïÃæÓÐûÓÐÕâ¸ö¹¦ÄÜ£¿


ÔÚVBÀï¿ÉÒÔÖ±½Óµ÷ÓÃSQLÓï¾ä¡£

²»·Á°ÑÄãÏë×öµÄÊÂÇé˵µÄ¸ü¾ßÌåЩ£¬´ó¼Ò²ÅºÃ°ïÄã³öÖ÷Òâ

Â¥Ö÷˵µÄ¹¦ÄÜÀàËÆÓÚ¼¯ºÏ²Ù×÷£¬VBÖв»Ö§³Ö¡£
²»¹ý£¬Äã¿ÉÒÔʹÓÃÆäËû·½·¨À´ÊµÏÖÏà½üµÄ¹¦ÄÜ£¬Õâ¾ÍµÄ¾ßÌåÎÊÌâ¾ßÌå·ÖÎöÁË¡£²»ÖªÂ¥Ö÷¾ßÌåÏë×öʲô£¿

Çé¿öÊÇÕâÑù£¬²»ÊǾ­³£ÒªÅжÏif x=b or x=y or x=z then ÕâÑùµÄÌõ¼þÂð¡£ÎÒÏë¿É·ñÀàËÆSQLÖÐµÄ where x in('b','y','z')£¬²»ÓÃдÄÇô¶àorÁË¡£

ÒýÓÃ
Çé¿öÊÇÕâÑù£¬²»ÊǾ­³£ÒªÅжÏ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


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

ΪʲôÓÃVB¸Ä±ä²»Á˹¤¾ßÀ¸°´Å¤µÄ¿í¶È - VB / ¿Ø¼þ

Ϊʲô¹¤¾ßÀ¸°´Å¤µÄ¿í¶È¸Ä±ä²»ÁË,ÔÚÊôÐÔÀï¸ÄÁËÓÖ±ä³ÉÔ­À´µÄÊýÖµÁË

´óºú×ÓÕæÀ÷º¦£¬»Ø´ð»ù±¾¶¼ÊDZ¬Áϼ¶µÄ
´óºú×ÓÉý¼¶Õæ¿ì°¡£¬Õâ²Å¼¸Ìì¾Í5Ìõ¶Ì¿ãÍâ¼ÓÔÂÅÅÃûµÚÒ»ÁË
ÏëÏëÎÒÕâ5¸ö¶Ì¿ã»ìÁ˲¶à8Äê²ÅµÃµ½µÄ¡£

»Ø¸´ ......

sql º¯ÊýÎÊÌâ

sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔΠ µ ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ