vs2008´øµÄsqlserverºÍsqlserverÓÐʲô¹ØÏµ£¿
3GµÄVS2008£¬ºÃÏñĬÈϰ²×°µÄʱºò´øÁ˺ܶණÎ÷¡£±ÈÈçsqlserver2005£¬µ«ÊÇÎÒ²»ÖªµÀÕâ¸ö¸½´øµÄsqlserver2005ºÍsqlserver2005ÓÐʲô¹ØÏµ£¿
Ò»¸öÊÇÔËÐл·¾³£¬Ò»¸öÊdzÌÐò£¿
Èç¹û×°ÁËvs2008£¬ÔÙ×°sqlserver2005ºÃÏñÓÖÌáʾÒѾ°²×°£¬µ¼ÖÂsqlserver2005×°²»ÉÏ¡£
µ«ÊDz»×°µÄ»°ÓÖÕÒ²»µ½Êý¾Ý¿â²éѯÆ÷Ö®ÀàµÄ¶«Î÷
µÈ´ýºóÃæ»Ø´ð ÎÒÒ²ÏëÖªµÀ
Ïà¹ØÎÊ´ð£º
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÔÚÊý¾Ý¿âÖÐÈÕÆÚÈçÏÂÏÔʾ£º2009-2-27 9:40:47
Õâ¸ö²»ÊÇÎÒÏëÒªµÄ£¬ÎÒÐèÒªÔ·ݺÍʱ¼äÓÃÁ½Î»Êý±íʾ£¬ÉÏÃæµÄÓ¦¸Ãת»»Îª;2009-02-27 09:40:47
ÇëÎÊ
1¡¢ÈçºÎ¶ÔÏÖÓÐÈÕÆÚ½øÐÐת»»£¨Êý¾Ý¿âÖÐÒÑ´æÔÚÐí¶àÀàËÆµÄÖµ£¬ÎÒÐèÒª½«Æä ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
Sqlserver±í½á¹¹
Create table test
(
int parentID primary key identity(1,1),
int childID
)go
ps:childIDÖ¸¶¨parentIDÖµ
ÓÐÈçÏÂÊý¾Ý
parentID childID
1   ......