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://www.diybl.com/course/7_databases/sql/sqlServer/2009124/154621_2.html
Ò»¸öÌâÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµÄ ......
*¸ø¶à¸ö±äÁ¿¸³Öµ
functionÖ»ÄÜʹÓÃ
set (a,b,c)=(select a,b,c from #);
procedureÖ»ÄÜʹÓÃ
select a,b,c into a,b,c from #
*functionÎÞ·¨Ç¶Ì×µ÷ÓôøÓÐinout»òout²ÎÊýµÄprocedure£¬ÏÖÏóΪ£ºÎÞ·¨´´½¨¡£
½ñÌìµÄ½øÕ¹½áÂÛÊÇ£º
function¿ÉÒÔµ÷ÓÃÈκÎprocedure£¬µ«±ØÐëÉùÃ÷Ϊmodifies sql data£¬Í¬Ê±±ØÐë·µ»Øtable ......
1.¡¸¿ªÊ¼¡¹²Ëµ¥->ÔËÐÐ
--Æô¶¯sql server 2005 ·þÎñ
net start mssqlserver
--Í£Ö¹sql server 2005 ·þÎñ
net stop mssqlserver
2.¡¸¿ªÊ¼¡¹²Ëµ¥->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß
SQL Server Configuration Manager->SQL Server(MSSQLSERVER) ÓÒ»÷ Æô¶¯·þÎñ³É¹¦ºó£¬×´Ì¬ÏÔʾΪ“ÕýÔÚÔËÐ ......
ÔªÊý¾Ý¼ò½é
¡¡¡¡ÔªÊý¾Ý (metadata) ×î³£¼ûµÄ¶¨ÒåΪ"ÓйØÊý¾ÝµÄ½á¹¹Êý¾Ý"£¬»òÕßÔÙ¼òµ¥Ò»µã¾ÍÊÇ"¹ØÓÚÊý¾ÝµÄÐÅÏ¢"£¬ÈÕ³£Éú»îÖеÄͼÀý¡¢Í¼Êé¹ÝĿ¼¿¨ºÍÃûƬµÈ¶¼¿ÉÒÔ¿´×÷ÊÇÔªÊý¾Ý¡£ÔÚ¹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ (DBMS) ÖУ¬ÔªÊý¾ÝÃèÊöÁËÊý¾ÝµÄ½á¹¹ºÍÒâÒå¡£±ÈÈçÔÚ¹ÜÀí¡¢Î¬»¤ SQL Server »òÕßÊÇ¿ª·¢Êý¾Ý¿âÓ¦ÓóÌÐòµÄʱºò£¬ÎÒÃǾ³£Òª»ñ ......
create table aaa
(
id int primary key ,
name varchar(30) not null
)
create table bbb
(
id int primary key ,
name varchar(30) not null
)
--½»
select * from aaa
where exists
(
select * from bbb where aaa.id=bbb.id and aaa.name = bbb.name
)
--²î
select *
from bbb
where not exists
(
......