sqlServerÓû§saµÇ¼²»ÉÏÁË
±êÌâ: Á¬½Óµ½·þÎñÆ÷
------------------------------
ÎÞ·¨Á¬½Óµ½ LIJINING-PC¡£
------------------------------
ÆäËûÐÅÏ¢:
Òѳɹ¦Óë·þÎñÆ÷½¨Á¢Á¬½Ó£¬µ«ÊÇÔڵǼ¹ý³ÌÖз¢Éú´íÎó¡£ (provider: ¹²ÏíÄÚ´æÌṩ³ÌÐò, error: 0 - ¹ÜµÀµÄÁíÒ»¶ËÉÏÎÞÈκνø³Ì¡£) (Microsoft SQL Server£¬´íÎó: 233)
ÓйذïÖúÐÅÏ¢£¬Çëµ¥»÷: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
------------------------------
°´Å¥:
È·¶¨
------------------------------
SQL code:
--try
Ê×ÏÈÑ¡ÖзþÎñÆ÷(ÓÒ¼ü)->ÊôÐÔ->°²È«ÐÔ->·þÎñÆ÷Éí·ÝÑéÖ¤ÐÞ¸ÄΪ"SQL SERVERºÍWINDOWSÉí·ÝÑé֤ģʽ"
Æä´ÎÕ¹¿ª·þÎñÆ÷ÉϵÄ"°²È«ÐÔ"->µÇ½Ãû->Ñ¡ÖÐSAµÇ½ÕʺÅ(ÓÒ¼ü)->״̬->µÇ½ÐÞ¸ÄΪÆôÓÃ
¶¼ÉèÖùýÁË£¬Ö®Ç°ÊÇÄܵǼÉÏ£¬Í»È»¾Í²»ÐÐÁË
ÊDz»ÊÇÉèÖÃÃüÃû¹ÜµÀÁË£¿Ò»°ãÉèÖÃÃüÃû¹ÜµÀºó»áµ¼ÖÂÎÞ·¨Á¬½Ó¡£°ÑÃüÃû¹ÜµÀ½ûµô¿´¿´¡£
Ïà¹ØÎÊ´ð£º
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
sql serverÖ±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐʲôÇø±ð?
´ó¼Ò˵Ïêϸһµã
²»Ã÷°×~~~
Ö±½Ó±¸·ÝÎļþµÄÓõķÖÀëÊý¾ÝºÍ¸½¼ÓÊý¾Ý¿â
sqlserver±¸·ÝµÄÓõı¸·ÝÊý¾Ý¿âºÍ»¹ÔÊý¾Ý¿â
Ö±½ÓÎļþ±¸·ÝÄãµÃÍ£·þÎñ»òÕßÍÑ ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
ÐèÇó˵Ã÷£º
ÔÚJSPǰִ̨ÐÐÒ»¸ö²Ù×÷£¬±¸·ÝºÃºǫ́SQLSERVERÊý¾Ý¿â±¸·Ý¡£
Çë¸÷λ´óϺ¸ø½éÉÜһϽâ¾ö·½°¸¡£
ǰ̨µ÷Óúǫ́µÄÒ»¸ö´æ´¢¹ý³Ì¾Í¿ÉÒÔÁË¡£
²»ÖªµÀ´æ´¢¹ý³ÌÔõôдÄØ£¿»¹ÇëÏ£ÍûÌṩһ¸ö·¶Àý¡£¸Ðл£¡
......