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

SQLÕù°ÔÈüÊÔÌâ¼°²Î¿¼´ð°¸

1.ijҽԺ²¡·¿¼ÆËã»ú¹ÜÀíÖÐÐèÒªÈçÏÂÐÅÏ¢£º£¨15·Ö£©
¿ÆÊÒ£º¿ÆÃû£¬¿ÆµØÖ·£¬¿Æµç»°
²¡·¿£º²¡·¿ºÅ£¬ËùÊô¿ÆÊÒÃû
Ò½Éú£ºÐÕÃû£¬Ö°³Æ£¬ËùÊô¿ÆÊÒÃû£¬ÄêÁ䣬¹¤×÷Ö¤ºÅ
²¡ÈË£º²¡ÀúºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬Õï¶Ï£¬Ö÷¹ÜÒ½Éú£¬²¡·¿ºÅ£¬ÈëסÈÕÆÚ
ÆäÖУ¬Ò»¸ö¿ÆÊÒÓжà¸ö²¡·¿¡¢¶à¸öÒ½Éú£¬Ò»¸ö²¡·¿Ö»ÄÜÊôÓÚÒ»¸ö¿ÆÊÒ£¬Ò»¸öÒ½ÉúÖ»ÊôÓÚÒ»¸ö¿ÆÊÒ£¬µ«¿É¸ºÔð¶à¸ö²¡È˵ÄÕïÖΣ¬Ò»¸ö²¡È˵ÄÖ÷¹ÜÒ½ÉúÖ»ÓÐÒ»¸ö£¬Ò»¸ö²¡ÈË¿ÉÄÜÔÚ²»Í¬Ê±¼äÈëס²»Í¬µÄ²¡·¿£¬Ò²ÊǾÍ˵һ¸ö²¡ÈËÒ²ÐíÈëס¹ý¶à¼ä²¡·¿£¬Ò»¼ä²¡·¿¿ÉÒÔÈëס¶àÃû²¡ÈË¡£
Íê³ÉÈçÏÂÉè¼Æ£º
£¨1£©       Éè¼Æ¸Ã¼ÆËã»ú¹ÜÀíϵͳµÄE£­Rͼ£¨7·Ö£©£»
´ð°¸£¨ÊµÌåÉϵÄÊôÐÔÃèÊö¼°¹ØÏµÃèÊöÂÔ£©»­³öËĸöʵÌåͼ£¬È»ºó¹ØÏµÃèÊöÕýÈ·¼´¿É¡£
 
£¨2£©       ½«¸ÃE-Rͼת»»ÎªÊý¾Ý¿âÄ£ÐÍͼ(±íÃûºÍ×Ö¶ÎÃû¶¼¿ÉÒÔÓÃÖÐÎÄÀ´Ð´)£¨8·Ö£©£»
´ð°¸£º
2. £¨75·Ö£©
±íÃû
S
×÷ÓÃ
´æ´¢Ñ§ÉúÐÅÏ¢
Ö÷¼ü
SNO
ÐòºÅ
×Ö¶ÎÃû³Æ
×Ö¶Î˵Ã÷
ÀàÐÍ
ÊôÐÔ
±¸×¢
1
SNO
Ö÷¼ü£¬Ñ§ºÅ
Varchar(5)
·Ç¿Õ
ѧºÅ±ØÐëΪÊý×Ö
2
SName
ѧÉúÐÕÃû
Nvarchar(50)
·Ç¿Õ
ÐÕÃûΨһ
3
Age
ÄêÁä
Int
·Ç¿Õ
1~100
4
Sex
ÐÔ±ð
Nvarchar(1)
·Ç¿Õ
ĬÈÏΪÄУ¬Ö»ÄÜÌîдÄкÍÅ®
 
±íÃû
C
×÷ÓÃ
´æ´¢¿Î³ÌÐÅÏ¢
Ö÷¼ü
CNO
ÐòºÅ
×Ö¶ÎÃû³Æ
×Ö¶Î˵Ã÷
ÀàÐÍ
ÊôÐÔ
±¸×¢
1
CNO
Ö÷¼ü£¬¿Î³ÌºÅ
char(2)
·Ç¿Õ
¿Î³ÌºÅ³¤¶È±ØÐëΪ2
2
CName
¿Î³ÌÃû
Nvarchar(50)
·Ç¿Õ
Ψһ
3
Teacher
ÀÏʦÐÕÃû
Nvarchar(50)
·Ç¿Õ
 
 
±íÃû
SC
×÷ÓÃ
´æ´¢³É¼¨ÐÅÏ¢
Ö÷¼ü
CNO,SNO
ÐòºÅ
×Ö¶ÎÃû³Æ
×Ö¶Î˵Ã÷
ÀàÐÍ
ÊôÐÔ
±¸×¢
1
CNO
¿Î³ÌºÅ£¬Íâ¼ü
char(2)
·Ç¿Õ
¿Î³ÌºÅ³¤¶È±ØÐëΪ2
2
SNO
ѧÉúºÅ£¬Íâ¼ü
Varchar(5)
·Ç¿Õ
ѧºÅ±ØÐëΪÊý×Ö
3
Grade
³É¼¨
Int
·Ç¿Õ
0~100
 
2.1 д³öSQLÓï¾ä£¬½¨Á¢Ñ§ÉúÊý¾Ý¿âStudent£¬²¢°´ÒÔÉÏÒªÇó½¨Á¢±í£¬Ô¼Êø£¨13·Ö£©£¨´ð°¸ÂÔ£©£»
2.2 ²åÈëһϲâÊÔÊý¾Ý£º£¨2·Ö£©
INSERT [C] ([CNO],[CName],[Teacher]) VALUES ( 'k1','CÓïÑÔ','Íõ»ª')
INSERT [C] ([CNO],[CName],[Teacher]) VALUES ( 'K5','Êý¾Ý¿âÔ­Àí','³Ì¾ü')
INSERT [C] ([CNO],[CName],[Teacher]) VALUES ( 'K8','±àÒëÔ­Àí','³Ì¾ü')
 
INSERT [S] ([SNO],[SName],[Age],[sex]) VALUES ( '1','ÀîÇ¿',23,'ÄÐ')
INSERT [S] ([SNO],[SName],[Age],[sex]) VALUES ( '2','ÁõÀö',22,


Ïà¹ØÎĵµ£º

DateDiff: SQL serverº¯Êý

 ·µ»Ø Variant (Long) µÄÖµ£¬±íʾÁ½¸öÖ¸¶¨ÈÕÆÚ¼äµÄʱ¼ä¼ä¸ôÊýÄ¿¡£
¡¡¡¡Óï·¨
¡¡¡¡DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
¡¡¡¡DateDiff º¯ÊýÓï·¨ÖÐÓÐÏÂÁÐÃüÃû²ÎÊý£º
¡¡¡¡²¿·Ö ÃèÊö
¡¡¡¡interval ±ØÒª¡£×Ö·û´®±í´ïʽ£¬±íʾÓÃÀ´¼ÆËãdate1 ºÍ date2 µÄʱ¼ä²îµÄʱ¼ä¼ä¸ô
¡¡¡¡Date1 ......

SQL Êý¾Ý¿â¼ä¸´ÖƱí

·½·¨Ò»£º
DB1  tb1  
DB2  tb2
Ñ¡ÔñDB1 µ½±íµÄÁбíÄÇÀï
Ñ¡Ôñtb1±í ÓÒ¼ü ËùÓÐÈÎÎñ Êý¾Ýµ¼³ö
ÏÂÒ»²½  Ñ¡ÔñÄãÒªµ¼³öµÄÊý¾Ý¿âDB1  ÏÂÒ»²½ Ñ¡ÔñÄãÒªµ¼ÈëµÄÊý¾Ý¿âDB2
ÏÂÒ»²½  Ñ¡ÔñÄãÒªµ¼µÄ±í£¨Ç°Ãæ»­¹´£©tb1£¬ ºóÃæ¶ÔÓ¦µÄÊÇÐÂÊý¾Ý¿âµÄ±íÃûtb2£¨Ä¬ÈÏÊÇÏàͬ±íÃû£¬¿ÉÐ޸ģ© ÏÂÒ»²½ ÍêÁË ......

oracle±È½Ï¿ìµÄ·ÖÒ³sql

 ·½°¸1 ÊÊÓÃÓÚoracle9iÒÔÉÏ£¡
select * from
(select row_number() over(order by sendid desc) rn,m.* from xxt_msgreceive m )
where rn <1010 and rn>=1000
·½°¸2
SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from xxt_msg where sendstatus=1  order by msgid desc) A WHERE ROWNUM < ......

SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓÃ

 Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄsql serverÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý£¨clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý£©ºÍ·Ç¾Û¼¯Ë÷Òý£¨nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý£©¡£ÏÂÃæ£¬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
¡¡¡¡Æäʵ£¬ÎÒÃǵĺºÓï× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ