sqlserverÖбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈµÄº¬Òå
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ÜÀàËÆ£¬µ«ÊÇ IDENTITY º¯Êý²»ÊÇÓë CREATE TABLE ºÍ ALTER TABLE Ò»ÆðʹÓÃµÄ IDENTITY ÊôÐÔ¡£
Óï·¨
IDENTITY ( data_type [ , seed , increment ] ) AS column_name
²ÎÊý
data_type
±êʶÁеÄÊý¾ÝÀàÐÍ¡£±êʶÁеÄÓÐЧÊý¾ÝÀàÐÍ¿ÉÒÔÊÇÈκÎÕûÊýÊý¾ÝÀàÐÍ·ÖÀàµÄÊý¾ÝÀàÐÍ£¨bit Êý¾ÝÀàÐͳýÍ⣩£¬Ò²¿ÉÒÔÊÇ decimal Êý¾ÝÀàÐÍ¡£
seed
ÒªÖ¸Åɸø±íÖеÚÒ»ÐеÄÖµ¡£¸øÃ¿Ò»¸öºóÐøÐÐÖ¸ÅÉÏÂÒ»¸ö±êʶֵ£¬¸ÃÖµµÈÓÚÉÏÒ»¸ö IDENTITY Öµ¼ÓÉÏ increment Öµ¡£Èç¹û¼ÈûÓÐÖ¸¶¨ seed£¬Ò²Ã»ÓÐÖ¸¶¨ increment£¬ÄÇôËüÃǶ¼Ä¬ÈÏΪ 1¡£
increment
ÓÃÀ´Ìí¼Óµ½ seed ÖµÒÔ»ñµÃ±íÖÐÁ¬ÐøÐеÄÔöÁ¿¡£
column_name
½«²åÈ뵽бíÖеÄÁеÄÃû³Æ¡£
seed
ÒªÖ¸Åɸø±íÖеÚÒ»ÐеÄÖµ¡£¸øÃ¿Ò»¸öºóÐøÐÐÖ¸ÅÉÏÂÒ»¸ö±êʶֵ£¬¸ÃÖµµÈÓÚÉÏÒ»¸ö IDENTITY Öµ¼ÓÉÏ increment Öµ¡£Èç¹û¼ÈûÓÐÖ¸¶¨ seed£¬Ò²Ã»ÓÐÖ¸¶¨ increment£¬ÄÇôËüÃǶ¼Ä¬ÈÏΪ 1
seedÖÖ×Ó
±êʶ ×ÔÔöÁÐ
¹«Ê½??ºÍÊýѧµÄ¹«Ê½²î²»¶à
Ïà¹ØÎÊ´ð£º
СµÜÏÖÔÚSwingÔÚÁ¬½ÓÊý¾Ý¿âÉÏÓöµ½Ò»µãÎÊÌ⣬ÇëÎÊSwingÀïÃæµÄʼþºÍSQLserverÊý¾Ý¿âµÄÁ¬½ÓÓÐʲôºÃµÄ×ÊÁÏÊéÍÆ¼öÂð£¿
Õâ¸öÓ¦µ±Ã»ÓÐÊ²Ã´ÌØ±ð,ÓëÆäËûµÄ±à³ÌÒ»Ñù.
JDBC
ÇëÎÊÔÚSwingÖмÓÔØ±³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿
......
sqlserver 2005
ÏûÏ¢ 8152£¬¼¶±ð 16£¬×´Ì¬ 14£¬µÚ 1 ÐÐ
½«½Ø¶Ï×Ö·û´®»ò¶þ½øÖÆÊý¾Ý¡£
Óï¾äÒÑÖÕÖ¹¡£
ÎÒÈ·¶¨²åÈëµÄÊý¾Ý¶¼·ûºÏÒªÇó ÒòΪÎÒÔÚjspÒ³Ãæ ÓÃÏàͬµÄÊý¾ÝÌá½»³É¹¦µ½Êý¾Ý¿â ¶øÎÒÔÚÊý¾Ý¿âдinser ......
sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ£¿µ«ÊÇ´ò¿ªÒ»¸öÔø¾´Óaccess·´ÏòµÃµ½µÄpdmºó£¬ÔÙת»»µ½´ËpdmÀï²»»á±¨´íÎ󣬵«ÊÇ´ò¿ªÆäËûpdm»òÕßн¨Ò»¸öpdm,¶¼»á±¨ÏÂÃæ´íÎó£¬Çë´ó¼Ò°ïÎÒ¿´¿´°É£¬Ê®· ......
ÔÚÊý¾Ý¿âÖÐÈÕÆÚÈçÏÂÏÔʾ£º2009-2-27 9:40:47
Õâ¸ö²»ÊÇÎÒÏëÒªµÄ£¬ÎÒÐèÒªÔ·ݺÍʱ¼äÓÃÁ½Î»Êý±íʾ£¬ÉÏÃæµÄÓ¦¸Ãת»»Îª;2009-02-27 09:40:47
ÇëÎÊ
1¡¢ÈçºÎ¶ÔÏÖÓÐÈÕÆÚ½øÐÐת»»£¨Êý¾Ý¿âÖÐÒÑ´æÔÚÐí¶àÀàËÆµÄÖµ£¬ÎÒÐèÒª½«Æä ......