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

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ÖÖ×Ó
±êʶ ×ÔÔöÁÐ
¹«Ê½??ºÍÊýѧµÄ¹«Ê½²î²»¶à

ÒýÓÃ
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£

¾¡¹ÜÀàËÆ£¬µ«ÊÇ IDENTITY º¯Êý²»ÊÇÓë CREATE TABLE ºÍ ALTER TABLE Ò»ÆðʹÓÃµÄ IDENTITY ÊôÐÔ¡£

Óï·¨
IDENTITY ( data_type [ , seed , increment ] ) AS column_name
<


Ïà¹ØÎÊ´ð£º

Ö±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐÊ²Ã´Çø±ð

sql serverÖ±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐÊ²Ã´Çø±ð?
´ó¼Ò˵Ïêϸһµã

²»Ã÷°×~~~

Ö±½Ó±¸·ÝÎļþµÄÓõķÖÀëÊý¾ÝºÍ¸½¼ÓÊý¾Ý¿â
sqlserver±¸·ÝµÄÓõı¸·ÝÊý¾Ý¿âºÍ»¹Ô­Êý¾Ý¿â

Ö±½ÓÎļþ±¸·ÝÄãµÃÍ£·þÎñ»òÕßÍÑ ......

ÇëÎÊnetbeans6.7.1 ÈçºÎÓë SqlServer Á¬½Ó£¿

     
      ÇëÎÊnetbeans6.7.1  ÈçºÎÓë SqlServer Á¬½Ó£¿

      Èç¹ûÊÇ ÔÚ NetBeansµÄ ·þÎñ ÊôÐÔ¿ò ÉèÖÃʲô Êý¾Ý¿â¡¢·þÎñÆ÷ µÄ£¬Âé·³Çë¸ø³ö¹ý³Ì ......

sqlserver 2005 ½«½Ø¶Ï×Ö·û´®»ò¶þ½øÖÆÊý¾Ý

sqlserver 2005
ÏûÏ¢ 8152£¬¼¶±ð 16£¬×´Ì¬ 14£¬µÚ 1 ÐÐ
½«½Ø¶Ï×Ö·û´®»ò¶þ½øÖÆÊý¾Ý¡£
Óï¾äÒÑÖÕÖ¹¡£

ÎÒÈ·¶¨²åÈëµÄÊý¾Ý¶¼·ûºÏÒªÇó ÒòΪÎÒÔÚjspÒ³Ãæ ÓÃÏàͬµÄÊý¾ÝÌá½»³É¹¦µ½Êý¾Ý¿â ¶øÎÒÔÚÊý¾Ý¿âдinser ......

sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ

    sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ£¿µ«ÊÇ´ò¿ªÒ»¸öÔø¾­´Óaccess·´ÏòµÃµ½µÄpdmºó£¬ÔÙת»»µ½´ËpdmÀï²»»á±¨´íÎ󣬵«ÊÇ´ò¿ªÆäËûpdm»òÕßн¨Ò»¸öpdm,¶¼»á±¨ÏÂÃæ´íÎó£¬Çë´ó¼Ò°ïÎÒ¿´¿´°É£¬Ê®· ......

ÈçºÎÔÚÒ»¸öÏîÄ¿Àï¼ÈÁ¬½ÓSQLserverÓÖÁ¬½ÓORACLE

ÎÒÒ»¸öÏîÄ¿ÀïÒªÁ¬½ÓSQLserverºÍORACLEÁ½¸öÊý¾Ý¿â£¬
·â×°ÀàÀïÃæÓõÄÊÇusing System.Data.OleDb;  £¨±¾ÈËÓõÄÊÇC#£©
ÏëÄDzÙ×÷ÕâÁ½¸öÊý¾Ý¿âµÄÀà·â×°ÔÚÒ»Æð£¬ ÈçºÎ×öÄØ£¿  ÓÐûÄÄλÓÐдºÃÁ˵ģ¿
Óù¤³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ