linq to sql ÖеÄin ²Ù×÷ʵÏÖ
string s = " 80,81,83,82";
string[] s1 = s.Split(',');
int[] p = new int[s1.Count()];
for (int i = 0; i < s1.Count(); i++)
{
p.SetValue(Convert.ToInt32(s1[i]), i);
}
public IQueryable<tbQuestions> SelectQuestions(int[] p)
{
var result = from s1 in db.tbQuestions
where !p.Contains(s1.id) && s1.deleteFlag == 0
select s1;
return result;
}
Ïà¹ØÎĵµ£º
ÔÌû¼°ÌÖÂÛ£ºhttp://bbs.bc-cn.net/dispbbs.asp?boardid=12&id=140292
* ×î½üÒòΪ¿ª·¢»î¶¯ÐèÒª,ÓÃÉÏÁËEclipse,²¢ÒªÇóʹÓþ«¼ò°æµÄSQLÊý¾Ý¿â(¼´SQL Server 2005)À´½øÐпª·¢ÏîÄ¿ *
1.×¼±¸¹¤×÷: ×¼±¸Ïà¹ØµÄÈí¼þ(Eclipse³ýÍâ,¿ªÔ´Èí¼þ¿ÉÒÔ´Ó¹ÙÍøÏÂÔØ)
<1> .Microsoft   ......
ÔªÊý¾Ý¼ò½é
¡¡¡¡ÔªÊý¾Ý (metadata) ×î³£¼ûµÄ¶¨ÒåΪ"ÓйØÊý¾ÝµÄ½á¹¹Êý¾Ý"£¬»òÕßÔÙ¼òµ¥Ò»µã¾ÍÊÇ"¹ØÓÚÊý¾ÝµÄÐÅÏ¢"£¬ÈÕ³£Éú»îÖеÄͼÀý¡¢Í¼Êé¹ÝĿ¼¿¨ºÍÃûƬµÈ¶¼¿ÉÒÔ¿´×÷ÊÇÔªÊý¾Ý¡£ÔÚ¹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ (DBMS) ÖУ¬ÔªÊý¾ÝÃèÊöÁËÊý¾ÝµÄ½á¹¹ºÍÒâÒå¡£±ÈÈçÔÚ¹ÜÀí¡¢Î¬»¤ SQL Server »òÕßÊÇ¿ª·¢Êý¾Ý¿âÓ¦ÓóÌÐòµÄʱºò£¬ÎÒÃǾ³£Òª»ñ ......
ÔÚ¸ø¸÷ºÏ×÷ѧУ°²×°Ó¦ÓÃϵͳ¹ý³ÌÖУ¬·¢ÏÖѧУÀïµÄSQL SERVER 2000Êý¾Ý¿âËð»µÁË֨װºó¶¼·¢ÉúÁËͬÑùµÄÎÊÌ⣬ÄǾÍÊǰ²×°SQL SERVERÊý¾Ý¿â²»³É¹¦¡£ÔÒò£º¼´Ê¹Äãͨ¹ý¿ØÖÆÃæ°åÀïµÄ“Ìí¼Ó/ɾ³ý³ÌÐò” Õý³£µÄÐ¶ÔØSQL SERVERÊý¾Ý¿â£¬µ«ÊÇ£¬SQL SERVER»¹ÊÇûÓÐÍêÈ«Ð¶ÔØ¸É¾»£¬»¹ÐèÒªÊÖ¹¤½øÐÐһЩ²Ù×÷¡£Òò´ËÖØÐ°²×°²»³É¹¦£¬º ......
¹úÍâ¿Õ¼äÃ²ËÆ¶ÔÖÐÎıȽϸÐð Èç¹ûÊý¾ÝÀàÐÍÉè¼ÆÎª varchar ÀàÐ͵ϰ ´æ´¢µÄÊý¾Ý»ù±¾ÉÏÊÇ "£¿£¿£¿£¿"
ºÜ¼òµ¥ ½« varchar ÀàÐÍ Éè¼ÆÎª nvarchar ÀàÐÍ
create table cs
(
txt1 nvarchar(50) null
)
insert into cs (txt1 ) values ('²âÊÔ') -- Èë¿âʱÊý¾Ýʱ £¿£¿£¿£¿
insert into cs (txt ......
SQL·ÖÒ³
ÍòÄÜ·ÖÒ³
.net´úÂë
select top ÿҳÏÔʾµÄ¼Ç¼Êý * from topic where id not in
(select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id desc)  ......