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

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£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

SQL×ֶΣ¬ºáÏòÕ¹¿ª

ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN

¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª

ÐÕÃû  ¿ÆÄ¿      ³É¼¨
ÕÅÈý  Ó¢Óï    90
ÀîËÄ  Ó¢Óï&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ