shell½Å±¾¶ÁÈ¡rrdÎļþ½«Êý¾Ý²åÈësqlserverÊý¾Ý¿âÖÐ
ÓÃshell½Å±¾Ð´¸öС³ÌÐò£¬²»Í£µÄ¶ÁÈ¡rrdÎļþ£¬½«Êý¾Ý²åÈësqlserverÊý¾Ý¿âÖУ¬Çë¸ßÊÖ ½â´ð£¬ÔÚÏߵȣ¡£¡£¡
²»ÑÏÖØ£¬¿ÉÒÔ·ÃÎʱðµÄ·þÎñÆ÷µÄÊý¾Ý¿âÂð£¿
¸øÄãÒ»¸ö˼·£º
shell½Å±¾¶ÁÈ¡Îļþ£º¼ÙÉèÊý¾ÝÎļþÖÐÒ»ÐÐÊÇÒ»Ìõ¼Ç¼£¬¸ù¾Ý·Ö¸ô·ûºÍÊý¾Ý¿â±í½á¹¹£¨²é¿´Êý¾Ý¿â±í½á¹¹Ò²ÐèÒªµÇ¼Êý¾Ý¿â²éѯ£©À´Éú³ÉÏàÓ¦µÄinsertÓï¾ä£¬
È»ºóµÇ¼sqlserverÊý¾Ý¿â£¬Ö´Ðз½²ÅÉú³ÉµÄinsertÓï¾ä¼´¿É¡£
sqlserver²»ÖªµÀÔõÑùÁ¬½Ó£¬Èç¹ûÊÇmysqlµÄ£¬¿ÉÒÔÓÿͻ§¶ËÁ¬½Ó¡£orcalÒ²¿ÉÒÔÓÃsqlplusÁ¬½Ó¡£
Ö»ÒªÄÜÁ¬½ÓÉÏ£¬ÎÊÌâ¾Í¸ã¶¨ÁË£¬ÖÁÓÚ¶ÁÎļþ£¬²åÈëÊý¾Ý¶¼ºÜ¼òµ¥ÁË¡£
Ïà¹ØÎÊ´ð£º
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
ÓÐһ̨Êý¾Ý¿â·þÎñÆ÷£¬¿Í»§¶ËʹÓÃADO.NETÁ¬½Ósql£¬Ê¹ÓÃExecuteScalarÖ´ÐÐSQL INSERTÓï¾ä£¬È»ºó¿Í»§¶Ëˢв»Äܲéѯµ½ÐÂINSERTµÄÊý¾Ý£¬¹ý10Ãë×óÓÒ²ÅÄܲ鵽ÐÂÊý¾Ý
ʲôÔÒò
Äã×öÁË»º´æÂð£¿
û×ö»º´æ
Ôõô»áÄØ£¡ ......
Sqlserver±í½á¹¹
Create table test
(
int parentID primary key identity(1,1),
int childID
)go
ps:childIDÖ¸¶¨parentIDÖµ
ÓÐÈçÏÂÊý¾Ý
parentID childID
1   ......
¸÷λ´óÏÀÇë°ï°ï棬ÎÒµÄÊý¾Ý¿âÁ¬½Ó³ÌÐò³öÎÊÌâÁË£¬ÒÔǰҲ¾³£ÓûáÓõ½Ëü£¬µ«ÊÇÕâÒ»´Î²»ÖªµÀΪʲôһֱ¸ã²»¶¨£¬ÏÂÃæÊÇÎÒÒªÌáÎʵÄÎÊÌ⣺,°´Àí˵ÕâÖÖÎÊÌâºÜ¼òµ¥£¬Ò»°ã¾ÍÊÇÒòΪJAR °üûÓÐÒýÈëÔì³ÉµÄ£¬¿ÉÊÇÎÒµÄJAR°ü¶¼ÒýÈë ......