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ÖмÓÔØ±³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿
......
ÏÖÔÚÎҵı¾»úÊÇÓõÄsqlserver2000°æ±¾µÄ(¿ÉÒÔÕý³£µÄÁ¬½Ó)¡£Êý¾ÝÁ¬½ÓÈçÏ£ºproxool.xml
XML code:
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
......
PB10¡¢PB11Á¬½ÓSQLServer¹Ø¼ü×Ö: pb10¡¢pb11Á¬½Ósqlserver (×ªÔØ)
PB10¡¢PB11Á¬½ÓSQLServer (×ªÔØ)
2007-11-02 22:27
´ÓPB10¿ªÊ¼£¬Ã»ÓÐÁËmssql serverרÓýӿÚÁË£¬ÁíÒ»·½ÃæÊý¾Ý¿â¹ÜÀíϵͳ(DBMS)
»»³ÉÁË ......
Êý¾ÝÒÔ´óÎļþµÄ·½Ê½£¬´æÔÚÊý¾Ý¿âÖС£Îļþ´óС²»Ò»Ö£¬Óм¸°ÙKµÄ£¬Ò²ÓÐ1G¶àµÄ¡£Îļþ¸ñʽ²»Í³Ò»£¬ÓÐZIP£¬RAR£¬DWG£¬WPSµÈµÈ¡£
ÏÖÔÚÏë°Ñ´óÎļþµ¼³öµ½¾ÖÓòÍøÄÚµÄһ̨µçÄԵĹ²ÏíÎļþ¼ÐÄÚ£¨ÎÞSQL SERVER£¬ÓÐÓû§Ãû¼ ......
ÇëÎÊnetbeans6.7.1 ÈçºÎÓë SqlServer Á¬½Ó£¿
Èç¹ûÊÇ ÔÚ NetBeansµÄ ·þÎñ ÊôÐÔ¿ò ÉèÖÃʲô Êý¾Ý¿â¡¢·þÎñÆ÷ µÄ£¬Âé·³Çë¸ø³ö¹ý³Ì ......