Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
<


Ïà¹ØÎÊ´ð£º

Çóc#²Ù×÷sqlserverÊý¾Ý¿âÎÊÌâ

ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......

SQLserver µ¼³ö ´óÎļþ µ½¾ÖÓòÍøÄڵĵçÄÔ

Êý¾ÝÒÔ´óÎļþµÄ·½Ê½£¬´æÔÚÊý¾Ý¿âÖС£Îļþ´óС²»Ò»Ö£¬Óм¸°ÙKµÄ£¬Ò²ÓÐ1G¶àµÄ¡£Îļþ¸ñʽ²»Í³Ò»£¬ÓÐZIP£¬RAR£¬DWG£¬WPSµÈµÈ¡£

ÏÖÔÚÏë°Ñ´óÎļþµ¼³öµ½¾ÖÓòÍøÄÚµÄһ̨µçÄԵĹ²ÏíÎļþ¼ÐÄÚ£¨ÎÞSQL SERVER£¬ÓÐÓû§Ãû¼ ......

ÇëÎÊ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,¶¼»á±¨ÏÂÃæ´íÎó£¬Çë´ó¼Ò°ïÎÒ¿´¿´°É£¬Ê®· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ