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

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;
        }


Ïà¹ØÎĵµ£º

SQLÓï¾äʹÓà һ¸öÌâÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä

×ªÔØ×Ô: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”¿Î³Ì³É¼¨¸ßµÄ ......

DB2 ´¿SQL´æ´¢¹ý³ÌÓ뺯ÊýµÄһЩÏÞÖÆ

*¸ø¶à¸ö±äÁ¿¸³Öµ
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 ......

SQL SERVER 2005 ÈçºÎÆô¶¯·þÎñ

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) ÓÒ»÷ Æô¶¯·þÎñ³É¹¦ºó£¬×´Ì¬ÏÔʾΪ“ÕýÔÚÔËÐ ......

»ñÈ¡SQL ServerÔªÊý¾Ý·½·¨

ÔªÊý¾Ý¼ò½é
¡¡¡¡ÔªÊý¾Ý (metadata) ×î³£¼ûµÄ¶¨ÒåΪ"ÓйØÊý¾ÝµÄ½á¹¹Êý¾Ý"£¬»òÕßÔÙ¼òµ¥Ò»µã¾ÍÊÇ"¹ØÓÚÊý¾ÝµÄÐÅÏ¢"£¬ÈÕ³£Éú»îÖеÄͼÀý¡¢Í¼Êé¹ÝĿ¼¿¨ºÍÃûƬµÈ¶¼¿ÉÒÔ¿´×÷ÊÇÔªÊý¾Ý¡£ÔÚ¹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ (DBMS) ÖУ¬ÔªÊý¾ÝÃèÊöÁËÊý¾ÝµÄ½á¹¹ºÍÒâÒå¡£±ÈÈçÔÚ¹ÜÀí¡¢Î¬»¤ SQL Server »òÕßÊÇ¿ª·¢Êý¾Ý¿âÓ¦ÓóÌÐòµÄʱºò£¬ÎÒÃǾ­³£Òª»ñ ......

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
( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ