SQL Server Ë÷Òý»ù´¡ÖªÊ¶(4)
ÓÐЩÈË¿ÉÄܶÔÖ÷¼üºÍ¾Û¼¯Ë÷ÒýÓÐËù»ìÏý£¬ÆäʵÕâÁ½¸öÊDz»Í¬µÄ¸ÅÄÏÂÃæÊÇÒ»¸ö¼òµ¥µÄÃèÊö¡£²»Ïë¿´ÈÆ¿ÚÎÄ×ÖÕߣ¬Ö±½Ó¿´Á½ÕßµÄ¶Ô±È±í¡£ÓÈÆäÊÇ×îºóÒ»ÏîµÄ±È½Ï¡£
Ö÷¼ü£¨PRIMARY KEY £©
À´×ÔMSDNµÄÃèÊö£º
±íͨ³£¾ßÓаüº¬Î¨Ò»±êʶ±íÖÐÿһÐеÄÖµµÄÒ»ÁлòÒ»×éÁС£ÕâÑùµÄÒ»Áлò¶àÁгÆÎª±íµÄÖ÷¼ü (PK)£¬ÓÃÓÚÇ¿ÖÆ±íµÄʵÌåÍêÕûÐÔ¡£ÔÚ´´½¨»òÐ޸ıíʱ£¬Äú¿ÉÒÔͨ¹ý¶¨Òå PRIMARY KEY Ô¼ÊøÀ´´´½¨Ö÷¼ü¡£
Ò»¸ö±íÖ»ÄÜÓÐÒ»¸ö PRIMARY KEY Ô¼Êø£¬²¢ÇÒ PRIMARY KEY Ô¼ÊøÖеÄÁв»ÄܽÓÊÜ¿ÕÖµ¡£ÓÉÓÚ PRIMARY KEY Ô¼Êø¿É±£Ö¤Êý¾ÝµÄΨһÐÔ£¬Òò´Ë¾³£¶Ô±êʶÁж¨ÒåÕâÖÖÔ¼Êø¡£
Èç¹ûΪ±íÖ¸¶¨ÁË PRIMARY KEY Ô¼Êø£¬Ôò SQL Server 2005 Êý¾Ý¿âÒýÇæ ½«Í¨¹ýΪÖ÷¼üÁд´½¨Î¨Ò»Ë÷ÒýÀ´Ç¿ÖÆÊý¾ÝµÄΨһÐÔ¡£µ±ÔÚ²éѯÖÐʹÓÃÖ÷¼üʱ£¬´ËË÷Òý»¹¿ÉÓÃÀ´¶ÔÊý¾Ý½øÐпìËÙ·ÃÎÊ¡£Òò´Ë£¬ËùÑ¡µÄÖ÷¼ü±ØÐë×ñÊØ´´½¨Î¨Ò»Ë÷ÒýµÄ¹æÔò¡£
´´½¨Ö÷¼üʱ£¬Êý¾Ý¿âÒýÇæ »á×Ô¶¯´´½¨Î¨Ò»µÄË÷ÒýÀ´Ç¿ÖÆÊµÊ© PRIMARY KEY Ô¼ÊøµÄΨһÐÔÒªÇó¡£Èç¹û±íÖв»´æÔÚ¾Û¼¯Ë÷Òý»òδÏÔʽָ¶¨·Ç¾Û¼¯Ë÷Òý£¬Ôò½«´´½¨Î¨Ò»µÄ¾Û¼¯Ë÷ÒýÒÔÇ¿ÖÆÊµÊ© PRIMARY KEY Ô¼Êø¡£
¾Û¼¯Ë÷Òý
¾Û¼¯Ë÷Òý»ùÓÚÊý¾ÝÐеļüÖµÔÚ±íÄÚÅÅÐòºÍ´æ´¢ÕâЩÊý¾ÝÐС£Ã¿¸ö±íÖ»ÄÜÓÐÒ»¸ö¾Û¼¯Ë÷Òý£¬ÒòΪÊý¾ÝÐб¾ÉíÖ»Äܰ´Ò»¸ö˳Ðò´æ´¢¡£
ÿ¸ö±í¼¸ºõ¶¼¶ÔÁж¨Òå¾Û¼¯Ë÷ÒýÀ´ÊµÏÖÏÂÁй¦ÄÜ£º
¿ÉÓÃÓÚ¾³£Ê¹ÓõIJéѯ¡£
Ìṩ¸ß¶ÈΨһÐÔ¡£
Á½ÕߵıȽÏ
ÏÂÃæÊÇÒ»¸ö¼òµ¥µÄ±È½Ï±í
Ö÷¼ü
¾Û¼¯Ë÷Òý
ÓÃ;
Ç¿ÖÆ±íµÄʵÌåÍêÕûÐÔ
¶ÔÊý¾ÝÐеÄÅÅÐò£¬·½±ã²éѯÓÃ
Ò»¸ö±í¶àÉÙ¸ö
Ò»¸ö±í×î¶àÒ»¸öÖ÷¼ü
Ò»¸ö±í×î¶àÒ»¸ö¾Û¼¯Ë÷Òý
ÊÇ·ñÔÊÐí¶à¸ö×Ö¶ÎÀ´¶¨Òå
Ò»¸öÖ÷¼ü¿ÉÒÔ¶à¸ö×Ö¶ÎÀ´¶¨Òå
Ò»¸öË÷Òý¿ÉÒÔ¶à¸ö×Ö¶ÎÀ´¶¨Òå
ÊÇ·ñÔÊÐí null Êý¾ÝÐгöÏÖ
Èç¹ûÒª´´½¨µÄÊý¾ÝÁÐÖÐÊý¾Ý´æÔÚnull£¬ÎÞ·¨½¨Á¢Ö÷¼ü¡£
´´½¨±íʱָ¶¨µÄ PRIMARY KEY Ô¼ÊøÁÐÒþʽת»»Îª NOT NULL¡£
ûÓÐÏÞÖÆ½¨Á¢¾Û¼¯Ë÷ÒýµÄÁÐÒ»¶¨±ØÐë not null .
Ò²¾ÍÊÇ¿ÉÒÔÁеÄÊý¾ÝÊÇ null
²Î¿´×îºóÒ»Ïî±È½Ï
ÊÇ·ñÒªÇóÊý¾Ý±ØÐëΨһ
ÒªÇóÊý¾Ý±ØÐëΨһ
Êý¾Ý¼´¿ÉÒÔΨһ£¬Ò²¿ÉÒÔ²»Î¨Ò»¡£¿´Ä㶨ÒåÕâ¸öË÷ÒýµÄ UNIQUE ÉèÖá£
£¨ÕâÒ»µãÐèÒª¿´ºóÃæµÄÒ»¸ö±È½Ï£¬ËäÈ»ÄãµÄÊý¾ÝÁпÉÄܲ»Î¨Ò»£¬µ«ÊÇϵͳ»áÌæÄã²úÉúÒ»¸öÄã¿´²»µ½µÄΨһÁУ©
´´½¨µÄÂß¼
Êý¾Ý¿âÔÚ´´½¨Ö÷¼üͬʱ£¬»á×Ô¶¯½¨Á¢Ò»¸öΨһË÷Òý¡£
Èç¹ûÕâ¸ö±í֮ǰûÓоۼ¯Ë÷Òý£¬Í¬Ê±½¨Á¢Ö÷¼üʱºòûÓÐÇ¿ÖÆÖ¸¶¨Ê¹Ó÷Ǿۼ¯Ë÷Òý£¬Ôò½¨Á¢Ö÷¼üʱºò£¬Í¬Ê±½¨
Ïà¹ØÎĵµ£º
1 £¬¶ÔÓÚÈÕÆÚ×Ö¶Î×Ö¶Î
access±íʾΪ£º#1981-28-12#
SQLSERVER2000±íʾΪ£º''1981-02-12''
2,SQLÓï¾äÇø±ð£¬select ,update ÔÚ¶Ôµ¥±í²Ù×÷ʱ¶¼²î²»¶à£¬
µ«¶à±í²Ù×÷ʱupdateÓï¾äµÄÇø±ðACCESSÓëSQLSERVERÖеÄUpdateÓï¾ä¶Ô±È:
SQLSERVERÖиüжà±íµÄUpdateÓï¾ä:
Update Tab1
SET a.Name = b.Name
from Tab1 a,Tab2 b
Whe ......
DBCC DROPCLEANBUFFERS --Çå³ý»º³åÇø£¬±ãÓڶԱȲéѯʱ¼äºÍÐÔÄÜ£¬²»ÊÕ»º´æµÄÓ°Ïì
SET STATISTICS TIME ON --ÏÔʾ·ÖÎö¡¢±àÒëºÍÖ´Ðи÷Óï¾äËùÐèµÄºÁÃëÊý
sp_spaceused NSDoctorAdvice0705 -- ²é¿´±í¿Õ¼ä´óС
ÎÊÌâÌÖÂÛ£º
ÊÇ·ñÔö¼ÓÒ»¸ö¶ÀÁ¢µÄÎļþ×飬ÓÃÀ´´æ·ÅË÷Òý¡£Ä¿Ç°Êý¾Ý¿âµÄÖ»ÓÐÒ»¸öÎļþ×飬Îļþ·Ç³£´óµÄ»°£¬ ......
(ËÄ)ÆäËûÊéÉÏûÓеÄË÷ÒýʹÓþÑé×ܽá
¡¡¡¡1¡¢ÓþۺÏË÷Òý±ÈÓò»ÊǾۺÏË÷ÒýµÄÖ÷¼üËÙ¶È¿ì
¡¡¡¡ÏÂÃæÊÇʵÀýÓï¾ä£º(¶¼ÊÇÌáÈ¡25ÍòÌõÊý¾Ý)
¡¡¡¡select gid,fariqi,neibuyonghu,reader,title from Tgongwen
¡¡¡¡where fariqi='2004-9-16'
¡¡¡¡Ê¹ÓÃʱ¼ä£º3326ºÁÃë
¡¡¡¡select gid,fariqi,neibuyonghu,reader,title from Tgongwe ......
@echo off
C:
CD "C:\Program Files\WinRAR"
net stop MSSQLserver
winrar.exe a -ag"-[YYYY-MM-DD-HH-MM-SS]" -k -r -s
-ibck -inul "E:\SQL2000±¸·ÝÉú³ÉµÄÎļþ.rar" "E:\SQL2000ËùÔÚÊý¾Ý¿âµÄDataĿ¼µÄλÖÃ\*.*"
net
start MSSQLserver
net stop Mysql
winrar.exe a -ag"-[YYYY-MM-DD-HH-MM-SS]" -k -r -s ......
±í½á¹¹ÈçÏÂ:
id int 4
EntryID int 4
BlogID int 4
ÏÖÔÚÒªÇóÔÚ²åÈëʱ£¬²»ÔÊÐí²åÈëEntryIDÓëBlogID¶¼ÏàͬµÄ¼Ç¼£¬¼´±íÖв»ÔÊÐíÈÎÒâÁ½Ìõ¼Ç¼µÄEntryIDÓëBlogID¶¼Ïàͬ£¬EntryIDÓëBlogID¹¹³É¼Ç¼µÄΨһ±êʶ¡£
ÒÔÇ ......