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

SQL°æÍí¼äÐÂÎÅ

±¾½ÚÄ¿ÓÉ£º
±í½ã      ×ÔÐŵÄÅ®ÈË×îÃÀÀö
Ê÷¸ç      Ê®ÄêÊ÷ľ£¬°ÙÄêÊ÷ÈË
Ë®¸ç      ˮˮ¸ü½¡¿µ
ÁªºÏÔÞÖú²¥³ö
----------------------------------------------------------------------------------------------------
¹ÛÖÚÅóÓÑÍíÉϺ㬽ñÌìÊÇ2009Äê9ÔÂ9ºÅ£¬Å©ÀúÆßÔ¶þʮһ¡£»¶Ó­ÊÕ¿´Íí¼äÐÂÎÅ£¬ÎÒÊÇ¿¾Ñ¼
±¾Ê±¶ÎµÄÖ÷ÒªÄÚÈÝÓУº
¡¾°æÄÚÒªÎÅ¡¿
½Ìʦ½ÚÀ´ÁÙ£¬°æÄÚʦÉú´ò³ÉһƬ£¬Æø·ÕÈÈÁÒ¡¾ÐÂÎÅÁ´½Ó¡¿
ƦƦ·¢±í½ÚÈÕÑÝ˵¡¾ÐÂÎÅÁ´½Ó¡¿

¡¾ÓéÀÖ°ËØÔ¡¿
²Å¿¡ÇàÄê±íÑݼÆÊ±¾ø¼¼£¬ÈËÌåÄÖÖÓÊÇÔõÑùÁ¶³ÉµÄ£¿¡¾ÐÂÎÅÁ´½Ó¡¿
ÃÀÅ®¸ß¹Ù±»ÆØ°µÏä²Ù×÷£¬È¨Á¦ÓëÕýÒåÖ®ÕùË­½«Ð¦µ½×îºó£¿¡¾ÐÂÎÅÁ´½Ó¡¿
ÃÀòÄÐ×ÓÆµÆµ±»Í¬ÐÕÇ󰮣¬²»¿°É§ÈÅ¿¼ÂÇÕûÈÝ¡¾ÐÂÎÅÁ´½Ó¡¿
ȺÖÚÈÈÁÒÆÚÅιúÇì´ó¼Ù£¬ÓÐÈËÒÑ¿ªÊ¼ÌáǰÇì×£¡¾ÐÂÎÅÁ´½Ó¡¿
СÈýÉ¢·Ö£¬»ú»áÄѵò»ÈÝ´í¹ý¡¾ÐÂÎÅÁ´½Ó¡¿
----------------------------------------------------------------------------------------------------
¹ã¸æÍ¬Ñù¾«²Ê

С°®£ºÊ¦¸µÄãÔÚÄÄ£¿ÎÒÊÇÕæÐĵģ¡
ZS£ºÕ÷»é¡£ÒªÇó£ºÅ®µÄ£¬»îµÄ¡£
FC£ºÕ÷»é¡£ÒªÇ󣺳ÁÓãÂäÑã±ÕÔÂÐß»¨ÎÂÈá¶Ëׯ¡£·Ç³ÏÎðÈÅ¡£
±í½ã£º³ÁÓãÂäÑã±ÕÔÂÐß»¨ÎÂÈá¶ËׯÊÊÁäÅ®Ñý³ÏÕ÷ÌÆÉ®Ò»Ãû
С³æ:³ÏÕ÷ÊÊÁä´ÆÐÔС³æÒ»Ãû¹²¶ÈÓàÉú£¬ÒªÇó£ºÉ«ÔóÏÊÁÁ£¬ÅÀÐÐËÙ¶ÈÖеȣ¬ÉíÌ彡¿µÎÞÒìζ

----------------------------------------------------------------------------------------------------
»¶Ó­»ØÀ´
ÏÂÃæ¹Ø×¢Ò»ÏÂÃ÷ÌìµÄÌìÆø£º

Ã÷ÌìµÄÊÂÃ÷ÌìÔÙ˵

ÒÔÉϾÍÊDZ¾´ÎÐÂÎŵÄÈ«²¿


Ïà¹ØÎÊ´ð£º

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

²»Ã÷°×µÄSQL×¢ÈëÎÊÌâ

ÎÒÊý¾Ý¿âÊÇMSSQLµÄ£¬×òÌìËùÓÐµÄ±í±»×¢ÈëJS½Å±¾´úÂë,Óиö²»Ã÷°×µÄµØ·½À´ÎÊÎÊ´ó¼Ò

ÎÒ·¢ÏÖÓÐЩ±íÎÒ¸ù±¾Ã»Ê¹Óã¬Ò²Ã»ÓÐÈë¿âµÄASPÒ³ÃæºÍÓï¾ä£¬ËüÊÇÔÛ¸ö×¢ÈëµÄÄØ£¿
Ã²ËÆselectÓï¾äÊÇ¿ÉÒÔǶÌ׵İɣ¿
¿ÉÄÜÊÇwhere ......

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

C# Á¬½ÓSQLÊý¾Ý¿â³£ÓõÄÁ¬½Ó×Ö·û´®¸ÃÈçºÎд£¿

£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";   
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ