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

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 ÉèÖá£
£¨ÕâÒ»µãÐèÒª¿´ºóÃæµÄÒ»¸ö±È½Ï£¬ËäÈ»ÄãµÄÊý¾ÝÁпÉÄܲ»Î¨Ò»£¬µ«ÊÇϵͳ»áÌæÄã²úÉúÒ»¸öÄã¿´²»µ½µÄΨһÁУ©
 
 
 
´´½¨µÄÂß¼­
Êý¾Ý¿âÔÚ´´½¨Ö÷¼üͬʱ£¬»á×Ô¶¯½¨Á¢Ò»¸öΨһË÷Òý¡£
Èç¹ûÕâ¸ö±í֮ǰûÓоۼ¯Ë÷Òý£¬Í¬Ê±½¨Á¢Ö÷¼üʱºòûÓÐÇ¿ÖÆÖ¸¶¨Ê¹Ó÷Ǿۼ¯Ë÷Òý£¬Ôò½¨Á¢Ö÷¼üʱºò£¬Í¬Ê±½¨


Ïà¹ØÎĵµ£º

MySQL ×Ö·û¼¯µ¼ÖÂSQLÁ¬½ÓÖ®ºóÖÐÎÄÂÒÂëµÄÎÊÌ⣡

character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......

AccessºÍSQL2000ÖÐÓï¾äµÄÇø±ð

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 ......

ÀûÓÃSQL²éѯ²åÈëÊý¾Ý

ÈçºÎ½«sql²éѯ½á¹û£¨²»Ö¹Ò»Ï²åÈëµ½Ò»ÕűíÖУ¬ÎÒÃÇÒ»°ã¿ÉÒÔÓÃÈçÏÂÐÎʽµÄsql
insert into table1
select field1,field2,... from table2
where ... 
ËüÒªÇó¶ÔÓ¦µÄ²åÈëÏîÀàÐͱØÐëÒ»Ö¡£
ÁíÍ⣬µ±selectµÄ²éѯ½á¹ûÊÇtable1µÄËùÓÐ×ֶεÄʱºò£¬¿ÉÒÔÊ¡ÂÔtable1µÄÁÐ×ֶΣ¬Ð´³ÉÈçÏÂÐÎʽ£º
insert into table1(fie ......

QTPÊý¾Ý¿â¼ì²éµãÊÖ¶¯SQLд·¨

Ò»¡¢SQL Server¸ñʽ(±¾µØÎÞÐè°²×°SQL Server)
connectionstring(Á¬½Ó×Ö·û´®):
1.±¾µØÃ»Óд´½¨Êý¾ÝÔ´µÄ·½Ê½
DRIVER=SQL Server;SERVER=Êý¾Ý¿âIPµØÖ·;UID=Óû§Ãû;PWD=ÃÜÂë;APP=Microsoft Office 2003;WSID=±¾µØÖ÷»úÃû;DATABASE=Êý¾Ý¿âÃû
ʵÀý£º
DRIVER=SQL Server;SERVER=10.160.11.10;UID=sa;PWD=sa;APP=Microsoft Offi ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ