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

SQL_ѧÉú

 
µÚ¶þ²¿·Ö
1.ËùÓÐÄÐÉúµÄÐÕÃû¡¢ÄêÁä:
Select Sname£¬Sage
from student;
2.ËùÓÐÄêÁä´óÓÚ20£¬¼ÆËã»ú¿ÆѧϵѧÉúÃûµ¥:
SELECT Sname
from Student
WHERE Sage>20 AND Sdept='CS';
3.³É¼¨´óÓÚ60µÄѧÉúѧºÅ:
SELECT Sno
from SC
WHERE Grade>60;
4.³É¼¨ÔÚ70µ½80Ö®¼äµÄѧÉúѧºÅ:
SELECT Sno
from SC
WHERE Grade>70 AND Grade<80;
SELECT Sno ѧºÅ
from SC
WHERE Grade BETWEEN 70 AND 80;
5.1985µ½1989Äê³öÉúµÄѧÉúÐÕÃû:
SELECT Sname ÐÕÃû
from Student
WHERE 2009-Sage BETWEEN 1985 AND 1989;
SELECT Sname
from Student
WHERE 2009-Sage>1985 AND 2009-Sage<1989;
6.²éѯ³É¼¨²»ÔÚ70µ½85µÄ¼°¸ñѧÉúÃûµ¥:
SELECT DISTINCT Sname
from Student,SC
WHERE Student.Sno=SC.Sno AND Grade NOT BETWEEN 70 AND 80 AND Grade>60;
7.²éѯ³É¼¨ÊÇ70¡¢80¡¢90µÄѧÉúѧºÅ:
SELECT Sno
from SC
WHERE Grade IN(70,80,90);
8.²éѯ1985¡¢1989ÄêµÄѧÉúѧºÅºÍÐÕÃû:
SELECT Sno,Sname
from Student
WHERE 2009-Sage IN('1985','1989');
9.²éѯѧ·Ö²»ÊÇ3¡¢4¡¢5µÄ¿ÎºÅ:
SELECT Cno
from Course
WHERE Ccredit NOT IN(3,4,5);
10.²éѯ2002¼¶ËùÓÐѧÉúÇé¿ö:
SELECT *
from Student
WHERE Sno LIKE '2002%';
SELECT *
from Student
WHERE Sno='2002%';
11.²éѯÐÕÁõ'CS'ϵµÄÐÕÃûºÍÐÔ±ð:
SELECT Sname,Ssex
from Student
WHERE Sdept='CS' AND Sname LIKE 'Áõ%';
12.²éѯÐÕÁõ¡¢ÕÅ¡¢ÀîµÄѧÉúÃûµ¥:
SELECT Sname
from Student
WHERE Sname LIKE '[ÁõÕÅÀî]%';
13.²éѯ¿Î³ÌÃûº¬ÓÐÊý¾ÝµÄ¿Î³ÌÃû³ÆºÍѧ·Ö:
SELECT Cname,Ccredit
from Course
WHERE Cname LIKE '%Êý¾Ý%';
14.²éѯûÓвμӿ¼ÊÔ,¿Î³ÌºÅΪ001µÄѧÉúµÄѧºÅ:
SELECT Sno
from SC
WHERE Cno LIKE '001' AND Grade IS NULL;
15.ËùÓвμÓÁ˿γ̺ÅΪ002µÄѧÉúѧºÅ£¬³É¼¨¡£
SELECT Sno,Grade
from SC
WHERE Cno LIKE '%2';
16.²éѯËùÓÐ2002¼¶ÄÐÉúºÍMAϵµÄѧÉúѧºÅºÍÐÕÃû:
SELECT Sno,Sname
from Student
WHERE Sno LIKE '2002%' AND Ssex LIKE 'ÄÐ' OR Sdept LIKE 'MA';
17.²éѯËùÓÐ4ѧ·ÖºÍÏÈÐпÎΪ6µÄ¿Î³ÌºÅºÍ¿Î³ÌÃû:
SELECT Cno,Cname
from Course
WHERE Ccredit LIKE '4' AND Cpno LIKE '6';
18.²éѯ'CS'ϵѧÉúÃûµ¥,²¢°´ÄêÁä½µÐò,°´ÐÔ±ðÉýÐò:
SELECT Sname,Sage,Ssex
from Student
WHERE Sdept LIKE 'CS'
ORDER BY


Ïà¹ØÎĵµ£º

sql±àÒëÓëÖرàÒë

sql±àÒëÓëÖرàÒë
 
1.sp_recompile
ʹ´æ´¢¹ý³ÌºÍ´¥·¢Æ÷ÔÚÏ´ÎÔËÐÐʱÖØбàÒë¡£
2.sp_refreshview
Èç¹ûÊÓͼËùÒÀÀµµÄ»ù´¡¶ÔÏó·¢Éú¸ü¸Ä(Èç:±íÔö¼ÓÁËÒ»¸ö×Ö¶Î)£¬ÔòÊÓͼ²»»á×Ô¶¯¸üУ¬ÕâʱÐèÒªµ÷Óøô洢¹ý³ÌÀ´¶ÔÊÓͼ½øÐÐˢС£ÓÐÈË˵£¬ÖØдò¿ªÒ»ÏÂÊÓͼ¾Í¿ÉÒÔ¸üÐÂÊÓͼ£¬µ«ÎÒÊÔÁËûÓгɹ¦¡£
Àý1£ºË¢ÐÂÖ¸¶¨Ãû³ÆµÄÊÓͼ ......

SQL Server CE

 SQL Server CE 2.0µÄÈ«ÃûÊÇSQL Server 2000 Windows CE Edition version 2.0¡£
Àý×Ó1£º¹«Ë¾ÅÉÈËÈ¥²Ö¿âÑé»õ¡¢µã»õ£¬¿ÉÒÔ°ÑÇ嵥ͬ²½µ½Pocket PCÉÏ£¬È»ºóÔÚ²Ö¿âÀïÃæÖ±½ÓÔÚPPCÉÏÃæupdate£¬»Øµ½¹«Ë¾Ò»Í¬²½¾Í¿ÉÒÔÁË¡£·ñÔò°´ÕÕÔ­ÏÈ×ö·¨£¬ÐèÒªÏÈ´òÓ¡Ò»ÕÅÇåµ¥£¬»ØÀ´ÒÔºóÔÙ¼ÈëÒ»±é¡£
Àý×Ó2£ºÁªÏëÅÉÈËÉÏÃÅÀ´ÐÞµçÄÔ£¬ÒÔÇ°×ÜÊÇ´ ......

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

SQL Server CLRÈ«¹¦ÂÔÖ®Îå

Ò»¡¢ÕâÊÇÕâ¸öϵÁеÄ×îºóÒ»½ÚÁË£¬×Ô¶¨Ò帴ÔÓÊý¾ÝÀàÐÍÄ¿Ç°Ö»ÄÜͨ¹ýCLRÀ´ÊµÏÖ¡£ÎªÁËÔÚ SQL Server ÖÐÔËÐУ¬ÄúµÄ UDT ±ØÐëʵÏÖ UDT ¶¨ÒåÖеÄÒÔÏÂÒªÇó£º
1.¸Ã UDT ±ØÐëÖ¸¶¨ Microsoft.SqlServer.Server.SqlUserDefinedTypeAttribute¡£System.SerializableAttribute ¿ÉÑ¡Ó㬵«½¨ÒéʹÓá£
2.UDT ±ØÐëͨ¹ý´´½¨¹«¹²µÄ static£¨M ......

sqlÌâÖеÄÖÖÖÖ

ÔÚ×ösqlÌâʱ£¬ÎÒÃÇ×îÅÂÓöµ½Ìõ¼þ¸´ÔӵIJéѯÓï¾ä£¬ÒòΪ´ó¶àʱºòÐèÒªÁ½Èý¸ö×Ó²éѯÀ´ÊµÏÖ£¬
¶ø´ó¶àÊýͬѧ£¬¿ÉÒÔ˵¶¼±È½ÏÅÂ×Ó²éѯµÄ£¬ÒÔÇ°ÎÒÒ²±»ÕâЩÌâĿŪµÄÔÆÀïÎíÀïµÄ£¬
²»¹ý×ö¶àÁËÕâÀàµÄÌâÄ¿ºó·¢ÏÖ£¬ÆäʵҲÓÐÒ»¶¨¹æÂÉ£¬ÎÒÃÇ¿ÉÒÔ×ܽáÒ»Ì×ÊʺÏ×Ô¼ºµÄ·½·¨À´´¦Àí£¬
ÏÂÃæʱÎÒ¶Ô¸ÃÀàÌâÄ¿µÄ´¦Àí·½·¨£º
ÓйºÎï±íÈçÏ£º
ÌâÄ¿£º ²é ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ