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,
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
CREATE FUNCTION dbo.UF_GetInvoiceSerials( @bizCode VARCHAR(10))
RETURNS VARCHAR(100)
AS
BEGIN
DECLARE @ret AS VARCHAR(1000)
SELECT @ret=Coalesce(@ret + ', ','') +
CASE e.ID
  ......
1.
ËÀËøÔÀí
¸ù¾Ý²Ù×÷ϵͳÖеĶ¨Ò壺ËÀËøÊÇÖ¸ÔÚÒ»×é½ø³ÌÖеĸ÷¸ö½ø³Ì¾ùÕ¼Óв»»áÊͷŵÄ×ÊÔ´£¬µ«Òò»¥ÏàÉêÇë±»ÆäËû½ø³ÌËùÕ¾Óò»»áÊͷŵÄ×ÊÔ´¶ø´¦ÓÚµÄÒ»ÖÖÓÀ¾ÃµÈ´ý״̬¡£
ËÀËøµÄËĸö±ØÒªÌõ¼þ£º
»¥³âÌõ¼þ
(Mutual exclusion)
£º×ÊÔ´²»Äܱ»¹²Ïí£¬Ö»ÄÜÓÉÒ»¸ö½ø³ÌʹÓá£
ÇëÇóÓë± ......
³ÉÔ±Ãû³Æ˵Ã÷
BigInt
Int64¡£64 λµÄÓзûºÅÕûÊý¡£
Binary
Byte ÀàÐ굀 Array¡£¶þ½øÖÆÊý¾ÝµÄ¹Ì¶¨³¤¶ÈÁ÷£¬·¶Î§ÔÚ 1 µ½ 8,000 ¸ö×Ö½ÚÖ®¼ä¡£
Bit
Boolean¡£ÎÞ·ûºÅÊýÖµ£¬¿ÉÒÔÊÇ 0¡¢1 »ò ¿ÕÒýÓã¨ÔÚ Visual Basic ÖÐΪ Nothing£©¡£
Char
String¡£·Ç Unicode ×Ö·ûµÄ¹Ì¶¨³¤¶ÈÁ÷£¬·¶Î§ÔÚ 1 ......
--Ê¡¼¶ Provincial
--³ÇÊÐ City
create table Provincial(pid int,Provincial varchar(50),primary key (pid))
insert into Provincial values(1,'±±¾©ÊÐ')
insert into Provincial values(2,'Ìì½òÊÐ')
insert into Provincial values(3,'ÉϺ£ÊÐ')
insert into Provincial values(4,'Ö ......