Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......

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

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

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

²ËÄñÌáÎÊ£¬Çó¼òµ¥sql ?



±íA

Sup_code    st_sup_code    buy_code      buy_code1 
1001        400            &nbs ......

sqlÓï¾äÖÐÄܲ»ÄÜÕâÑùÅÅÐò£¿

Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©

ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ