Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mssql

accessת»»mssqlºó²éѯºÜÂý

accessʱ²éѯËٶȻ¹Âù¿ìµÄ£¬ÏÖÔÚת³ÉmssqlÁË£¬Êý¾ÝÁ¿²¢²»´ó£¬Í¨³£Êý¾ÝÁ¿¶àЩµÄ¾ÍÊǼ¸Ç§Ìõ£¬µ±È«²¿ÁгöÊý¾ÝʱËÙ¶ÈÒ²²»Âý£¬¾ÍÊÇ°´Ìõ¼þËÑË÷ʱ¾ÍÂýÁË£¬ÇëÎÊÊDz»ÊǸúlikeÓйذ¡£¬µ«ÒÔÇ°ÓÃaccessÂù¿ìµÄ°¡£¬Ò²½¨Á¢ÁËË÷ÒýÁË

ÎÒlikeÊÇÕâÑùд·¨µÄ
sqlstr += " and hbh like '%" + bh + "%'";
......

²éѯmssql´óÅúÁ¿Êý¾Ý

Êý¾Ý¿âÄÚÓÐ500WÌõÊý¾Ý£¬²éѯµÄʱºòÈçºÎÓÅ»¯
Õâ¶Îʱ¼äÒ²ÔÚ¿´SQL.ÎÒ¾õµÃÕâÁ½±¾Êé²»´í!SQLÒÕÊõ,SQL2008¼¼ÊõÄÚÄ» T-SQL»ù´¡.

ȷʵдһÌõ¸ßЧµÄSQL²»ÊÇÈÝÒ×µÄÊÂ!ÎҼǵÃ×îÇå³þµÄÒ»ÌõÊÇ:×î½ü¹ýÂ˵ô²»·ûºÏÌõ¼þµÄ¼Ç¼

500W.......Õâ¸ö½á¹ûË­¿´µÄÍê.
sqlÓï¾ä¸´ÔӵĻ°,½¨ÒéÓô洢¹ý³Ì. ÓÅ»¯Ã÷È·¾«È·µÄÊý¾Ý½á¹û½øÐвéѯ. ......

¹ØÓÚMSSQLÔ¼ÊøÃû³ÆµÄÎÊÌâ - MS-SQL Server / »ù´¡Àà

×ֶεÄĬÈÏÖµÔ¼ÊøÉúËùµÄÔ¼ÊøÃû³Æϵͳ³£³£ÔÚºóÃæÌíÉÏÒ»¸öËæ»úµÄ×Ö·û´®£¬
Èç
DF__Admin__locked__014935CB
ÕâÑùÔì³ÉÒÔºóÔÚÐ޸ĸÄÔ¼ÊøµÄʱºòºÜÂé·³£¬ÔõôÉèÖò»ÈÃÊý¾Ý¿â×Ô¶¯Éú³ÉÕâÑùµÄËæ»úÃû³ÆµÄÔ¼ÊøÃû³Æ
¶øÏòÕâÑù DF__Admin__locked
ÎÒÓõÄÊÇPDÉú³ÉµÄSQLÓï¾ä£¬Èç¹û¿ÉÒÔ£¬ÔÚPDÖÐÈçºÎÉèÖã¿
²»ÖªµÀ °ï¶¥

PD²»Çå³þ£¬ÄãÖ ......

mssql ¶Ì·ÅжÏÄÜʵÏÖÂð

cÓïÑÔÖеÄ&ºÍ&&£¬ÆäÖÐ&&¾ßÓжÌ·ÅжϹ¦ÄÜ£¬ÔÚmssqlÖÐÓжÌ·ÅжÏÂÎÒÓÃand²»ÐУ¬°Ñand»»³É&&±¨´íÁË
MSSQLÖÐûÓÐ&&

½«nvarchar Öµ '1g' ת»»ÎªÊý¾ÝÀàÐÍΪ int µÄÁÐʱ·¢ÉúÓï·¨´íÎó£¬Äܲ»ÄÜÈÃÕâ¸öÌø¹ý£¬¾ÍÊÇ˵²éÕÒµ½²»ÄÜת»»µÄ¾Í²»¹ÜËüÁË


Õâ¸ö£¬Ó¦¸ÃÊÇ¿ÉÒÔÓбä֮ͨ·¨µÄ ......

MSSQLÔõô»ñÈ¡Êý¾Ý¿âÀúÊ·²éѯ×Ü´ÎÊý

ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿
ÈçÌâ

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É


ÒýÓÃ
³ý·ÇÄãÒµÎñÉÏ×ö¼Ç¼£¬·ñÔòÄãÊDz»ÄÜÖªµÀµÄ¡£ÒòΪÈÕÖ¾²»¼Ç¼selectÓï¾äÃüÁî¡£
..

ÄÇÓÐûÓÐϵͳ´æ´¢¹ý³Ì»òÕßÈ«¾Öº¯ÊýÄܹ»»ñÈ¡ÄØ£¿

ÒýÓÃ
ÄÇÓÐûÓÐϵͳ´æ´¢¹ý³Ì»òÕßÈ«¾Öº¯ÊýÄܹ»»ñÈ¡ÄØ£¿
û

ÄÇͳ¼Æ· ......

¸ßÊÖ¿ìÀ´¾È¾ÈÎÒ¡£MSSQL²éѯÎÊÌâ

Dim Rs:Set rs=key28.exe("select [id],[big],[class] from lm_small")
Do while not rs.eof
    Dim rs1:Set rs1=key28.exe("select [class] from [lm_class] where id="&rs("big"))


ΪʲôÎÒʹÓÃRS£¨¡°big¡±£©¾Í»á³ö´í¡£¶øÖ±½ÓʹÓÃÈçid=1ÕâÑùµÄ²éѯÌõ¼ ......
×ܼǼÊý:200; ×ÜÒ³Êý:34; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [7] [8] [9] [10] 11 [12] [13] [14] [15] [16]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ