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

shell½Å±¾¶ÁÈ¡rrdÎļþ½«Êý¾Ý²åÈësqlserverÊý¾Ý¿âÖÐ

ÓÃshell½Å±¾Ð´¸öС³ÌÐò£¬²»Í£µÄ¶ÁÈ¡rrdÎļþ£¬½«Êý¾Ý²åÈësqlserverÊý¾Ý¿âÖУ¬Çë¸ßÊÖ ½â´ð£¬ÔÚÏߵȣ¡£¡£¡

²»ÑÏÖØ£¬¿ÉÒÔ·ÃÎʱðµÄ·þÎñÆ÷µÄÊý¾Ý¿âÂð£¿

¸øÄãÒ»¸ö˼·£º
shell½Å±¾¶ÁÈ¡Îļþ£º¼ÙÉèÊý¾ÝÎļþÖÐÒ»ÐÐÊÇÒ»Ìõ¼Ç¼£¬¸ù¾Ý·Ö¸ô·ûºÍÊý¾Ý¿â±í½á¹¹£¨²é¿´Êý¾Ý¿â±í½á¹¹Ò²ÐèÒªµÇ¼Êý¾Ý¿â²éѯ£©À´Éú³ÉÏàÓ¦µÄinsertÓï¾ä£¬
È»ºóµÇ¼sqlserverÊý¾Ý¿â£¬Ö´Ðз½²ÅÉú³ÉµÄinsertÓï¾ä¼´¿É¡£

sqlserver²»ÖªµÀÔõÑùÁ¬½Ó£¬Èç¹ûÊÇmysqlµÄ£¬¿ÉÒÔÓÿͻ§¶ËÁ¬½Ó¡£orcalÒ²¿ÉÒÔÓÃsqlplusÁ¬½Ó¡£


Ö»ÒªÄÜÁ¬½ÓÉÏ£¬ÎÊÌâ¾Í¸ã¶¨ÁË£¬ÖÁÓÚ¶ÁÎļþ£¬²åÈëÊý¾Ý¶¼ºÜ¼òµ¥ÁË¡£


Ïà¹ØÎÊ´ð£º

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

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

sqlserverÖбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈµÄº¬Òå

sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É

identity?ɶÒâ˼£¿

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

.NET²åÈëSQLSERVERÑÓʱÎÊÌ⣿ - .NET¼¼Êõ / C#

ÓÐһ̨Êý¾Ý¿â·þÎñÆ÷£¬¿Í»§¶ËʹÓÃADO.NETÁ¬½Ósql£¬Ê¹ÓÃExecuteScalarÖ´ÐÐSQL INSERTÓï¾ä£¬È»ºó¿Í»§¶Ëˢв»Äܲéѯµ½ÐÂINSERTµÄÊý¾Ý£¬¹ý10Ãë×óÓÒ²ÅÄܲ鵽ÐÂÊý¾Ý
ʲôԭÒò
Äã×öÁË»º´æÂð£¿

û×ö»º´æ

Ôõô»áÄØ£¡ ......

SQLSERVERÊý¾Ýµ¼³öµ½Access

Sqlserver±í½á¹¹
Create table test
(
  int parentID primary key identity(1,1),
  int childID
)go
ps:childIDÖ¸¶¨parentIDÖµ
ÓÐÈçÏÂÊý¾Ý
parentID childID
  1   ......

ÓйØsqlserver 2008 Á¬½Óʧ°ÜµÄÎÊÌâ

¸÷λ´óÏÀÇë°ï°ï棬ÎÒµÄÊý¾Ý¿âÁ¬½Ó³ÌÐò³öÎÊÌâÁË£¬ÒÔǰҲ¾­³£ÓûáÓõ½Ëü£¬µ«ÊÇÕâÒ»´Î²»ÖªµÀΪʲôһֱ¸ã²»¶¨£¬ÏÂÃæÊÇÎÒÒªÌáÎʵÄÎÊÌ⣺,°´Àí˵ÕâÖÖÎÊÌâºÜ¼òµ¥£¬Ò»°ã¾ÍÊÇÒòΪJAR °üûÓÐÒýÈëÔì³ÉµÄ£¬¿ÉÊÇÎÒµÄJAR°ü¶¼ÒýÈë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ