sql²éѯתΪlinq²éѯ
ÏÖÔÚÓÐÕâÑùÒ»Ìõ²éѯÓï¾ä delete from table1 where id in(1,2,3,4) Èç¹ûʹÓÃlinqÀ´¶ÔʵÌå½øÐвÙ×÷ÊÇÔõôдµÄÄØ£¿ ÆÚ´ý½â¾ö¡£ Áí×£´ó¼Ò¹úÇì¿ìÀÖ
×Ô¼º¶¥ÉÏÈ¥ ¶ÔLing²»ÊìϤŶ ¸Ð¾õÉϲ»ÁË´óÌ¨ÃæÒýÓà ¶ÔLing²»ÊìϤŶ ¸Ð¾õÉϲ»ÁË´óÌ¨Ãæ лл2Â¥¡£ ÔÙ¶¥ÉÏÈ¥ Any ÓÃÓÚÅжϼ¯ºÏÖÐÊÇ·ñÓÐÔªËØÂú×ãijһÌõ¼þ All ÓÃÓÚÅжϼ¯ºÏÖÐËùÓÐÔªËØÊÇ·ñ¶¼Âú×ãijһÌõ¼þ Contains ÓÃÓÚÅжϼ¯ºÏÖÐÊÇ·ñ°üº¬ÓÐÄ³Ò»ÔªËØ ²Î¿¼ÒýÓà Any ÓÃÓÚÅжϼ¯ºÏÖÐÊÇ·ñÓÐÔªËØÂú×ãijһÌõ¼þ All ÓÃÓÚÅжϼ¯ºÏÖÐËùÓÐÔªËØÊÇ·ñ¶¼Âú×ãijһÌõ¼þ Contains ÓÃÓÚÅжϼ¯ºÏÖÐÊÇ·ñ°üº¬ÓÐÄ³Ò»ÔªËØ ²Î¿¼ LSÒѾ·Ç³£ÏêϸµÄ°ïÖúµ½ÄãÁË£¬¹Ø¼üÊÇÄã×Ô¼ºÔõôѧϰÁË£¡ ²»»álinq ¶¥Ï up
Ïà¹ØÎÊ´ð£º
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123 aspÀïÃæ strday=100£¬strb=001 ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232" ½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË, ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿ try { connection.connect() return true; } catch() { return false; } Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£ ÒýÓà try { connection.connect( ......
table1 Ãû³Æ Èë¿âÊý CT»ú 3 CT»ú 5 X¹â»ú 4 ......