·¢²¼Ê±¼ä : ÐÇÆÚÁù ÎÄÕÂÊý¾Ý¿âÔÀíʵÑ鱨¸æ·ÖÎö - ͼÎĸüÐÂÍê±Ï¿ªÊ¼ÔĶÁ1f874e656ad97f192279168884868762cbaebb5c
2013¼¶ Êý¾Ý¿âÔÀí ʵÑ鱨¸æ
רҵ£º_______¼ÆËã»ú___ °à¼¶£º________________ ѧºÅ£º______________ ÐÕÃû£º_______________
2015Äê5ÔÂ
ʵÑéÒ» SQL Server 2005»ù±¾²Ù×÷
Ò»¡¢ÊµÑéÄ¿µÄ
Á˽âSQL Server 2005×é¼þ£» Á˽âSQL ServerÊý¾Ý¿â×é³É£»
ÕÆÎÕSQL Server 2005½çÃæ»ù±¾²Ù×÷¡£
¶þ¡¢ÊµÑéÄÚÈÝ
£¨1£©¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005-> SQL Server Management Studio£¬´ò¿ªºó½øÈëµ½SQL Server 2005Ö÷Ìå½çÃæ
£¨2£©µã»÷?Êý¾Ý¿â?Ç°ÃæµÄ?+?£¬¿ÉÒÔÕ¹¿ª²é¿´Êý¾Ý¿â£¬²¢ÇÒ¿ÉÒÔ¼ÌÐøÕ¹¿ªÏ¼¶Ä¿Â¼£¬²é¿´Êý¾Ý¿âÖÐµÄ±í¡¢ÊÓͼµÈ¡£
£¨3£©Á˽âSQL Server 2005²Ëµ¥À¸µÄһЩÖ÷Òª¹¤¾ßµÄʹÓᣠ£¨4£©Ñ§Éú¶¯ÊÖ²Ù×÷SQL Server 2005£¬´ò¿ªÊý¾Ý¿â£¬´ò¿ª±í£¬´ò¿ª²éѯ½çÃ棻²é¿´Êý¾Ý¿âµÄÊôÐÔ¡¢±íµÄÊôÐԵȡ£
Èý¡¢ÊµÑé×ܽá
½øÐÐÕâ´ÎʵÑéÓÐÓöµ½Ê²Ã´ÎÊÌ⣿Ôõô½â¾öµÄ£¿
´ð£º´Ë´ÎʵÑéÎÒÃÇÒ»²½Ò»²½°´ÕÕʵÑéÄÚÈݲÙ×÷µÄ£¬»ù±¾ÉÏûÓÐÓöµ½ÎÊÌâ¡£
ʵÑé¶þ Êý¾Ý¶¨Òå
Ò»¡¢ÊµÑéÄ¿µÄ
ÕÆÎÕSQL Server 2005µÄÊý¾Ý¿â´´½¨£» ÕÆÎÕSQL ServerÊý¾Ý¶¨ÒåÓïÑÔ£»
ÕÆÎÕSQL Server 2005Êý¾Ý¶¨ÒåµÄSQLÓïÑÔ¶¨ÒåÓë¹ÜÀíÆ÷¶¨ÒåÁ½ÖÖ·½Ê½¡£
¶þ¡¢ÊµÑéÄÚÈÝ
£¨1£©´´½¨¡¢Ð޸ġ¢É¾³ýÊý¾Ý¿â¡£
´´½¨ÒªÇó£ºÊý¾Ý¿âEmployeeÖаüº¬Ò»¸öÊý¾Ý¿âÎļþEmpdat1.mdfºÍÒ»¸öÈÕÖ¾ÎļþEmplog.ldf¡£ÆäÖУ¬Êý¾ÝÎļþ´óСΪ10MB£¬×î´óΪ50MB£¬ÒÔ5MBËÙ¶ÈÔö³¤£»ÈÕÖ¾Îļþ´óСΪ5MB£¬×î´óΪ25MB£¬ÒÔ5%ËÙ¶ÈÔö³¤¡£
ÐÞ¸ÄÒªÇó£ºÔö¼ÓµÚ¶þ¸öÊý¾Ý¿âÎļþEmpdat2.ndf£¬ÆäÖУ¬Êý¾ÝÎļþ´óСΪ5MB£¬×î´óΪ25MB£¬ÒÔ2MBËÙ¶ÈÔö³¤¡£
£¨2£©ÀûÓÃSQL´´½¨ÈËÔ±±íperson¡¢ÔÂн±ísalary¼°²¿Ãűídept¡£ ¼ûÉÏҳͼ
ÒªÇ󣺰´±í2-1¡¢±í2-2¼°±í2-3ÖеÄ×Ö¶Î˵Ã÷´´½¨¡£
×Ö¶ÎÃû P_no Sex BirthDate Prof Deptno Êý¾ÝÀàÐÍ Char Char Datetime Varchar Char ±í2-1 person±í½á¹¹ ×ֶγ¤¶È ÔÊÐí¿Õ·ñ ×Ö¶Î˵Ã÷ 6 Not Null ¹¤ºÅ£¬Ö÷¼ü 2 Not Null ÐÔ±ð Null ³öÉúÈÕÆÚ 10 Null Ö°³Æ 4 Not Null ²¿ÃÅ´úÂ룬Íâ¼ü(²ÎÕÕdept±í)
±í2-2 Salary±í½á¹¹ Êý¾ÝÀàÐÍ ×ֶγ¤¶È ÔÊÐí¿Õ·ñ ×Ö¶Î˵Ã÷ Char 6 Not Null ¹¤ºÅ£¬Ö÷¼ü£¬Íâ¼ü(²ÎÕÕperson±í) Dec 5 Null »ù±¾¹¤×Ê Dec 5 Null ½±½ð£¬ÒªÇó>50 ʵ·¢¹¤×Ê=»ù±¾¹¤×Ê+½±½ð Int Not Null Ô·Ý
±í2-3 dept±í½á¹¹
Êý¾ÝÀàÐÍ ×ֶγ¤¶È ÔÊÐí¿Õ·ñ ×Ö¶Î˵Ã÷ Char 4 Not Null ²¿ÃÅ´úÂ룬Ö÷¼ü Varchar 10 Not Null ²¿ÃÅÃû³Æ ×Ö¶ÎÃû P_no Base Bonus Fact Month
)
×Ö¶ÎÃû Deptno Dname
create table dept(
Deptno Char(4) Not Null,primary key(Deptno), Dname Varchar(10) Not Null,
create table person(
) )
create table Salary (
P_no Char(6) Not Null,foreign key(P_no) references person(P_no), Base Dec(5) Null, Bonus Dec(5) Null, Fact as Base+Bonus, Month Int Not Null, check (Bonus>50),
P_no Char(6) Not Null,primary key(P_no), P_name Varchar(10) Not Null, Sex Char(2) Not Null, BirthDate Datetime Null, Prof Varchar(10) Null,
Deptno Char(4) Not Null,foreign key(Deptno) references dept(Deptno),
£¨3£©ÀûÓÃSQLÓï¾ä´´½¨ÊÓͼ¡£
ÒªÇó£ºÔÚ»ù±ípersonÉÏ´´½¨Ô±¹¤ÊÓͼPersonView£¬ÆäÖаüº¬¹¤ºÅ¡¢ÐÕÃû¡¢ÐÔ±ð¡¢Ö°³ÆºÍ²¿ÃÅ´úÂëµÈ×ֶΡ£
create view PersonView (P_no,P_name,Sex,Prof,Deptno) as
select P_n,P_name,Sex,Prof,Deptno from person