Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

ÇóSQL£¿

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

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}

Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£

ÒýÓÃ
try
{
connection.connect( ......

ÇóÒ»¸ösql Óï¾ä

  table1
  Ãû³Æ      Èë¿âÊý
  CT»ú        3   
  CT»ú        5
  X¹â»ú      4 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ