MSSQLÈçºÎ²åÈë²»ÏàͬµÄ¼Ç¼ - .NET¼¼Êõ / ASP.NET
ÈçÌ⣬Óû§×¢²áʱ£¬Óû§ÃûÊDz»ÄÜÖظ´µÄ£¬ÈçºÎÅжϲåÈëµÄ¼Ç¼²»Öظ´ÄØ£¿ Çë¿´Çå³þÎÒµÄÌâÄ¿£¬²»Òª´ÓÍøÉϳһЩ´ð°¸¹ýÀ´£¬ÍøÉϺܶàÈËдµÄÏÈselectÔÙinsertµÄ¶¼ÊÇϹ³¶£¬Ñ¹¸ù¾Íû¿¼Âǵ½²¢·¢ÐÔÎÊÌ⣬ÎÒÏÖÔÚ²»Ïë¼ÓÉÏÐòÁл¯¸ôÀ뼶±ð£¬ÓÐûÓкÃÒ»µãµÄ½â¾ö·½°¸ ÎÒÒªÇóÊä³ö@_Output INT Êä³ö´óÓÚÁã±íʾ@@IDENTITY µÈÓÚ0±íʾ´æÔÚÏàͬ¼Ç¼ µÈÓÚ¸ºÊý±íʾ·¢Éú´íÎó¡£
°ÑÓû§ÃûÉèÖÃΪÖ÷¼ü»òÕßÊÇΨһµÄ£¬ÕâÑù²åÈëÒ»Ñù¾Í»á±¨´í£¬±£Ö¤²»»áÓÐÒ»ÑùµÄͬÑùµÄÊý¾Ý²åÈë Êǵģ¬Í¨¹ý@@ERRORȷʵ¿ÉÒԵõ½´íÎóÁË£¬ µ«ÈçºÎÅж¨Ò»¶¨ÊÇÒòΪÖ÷¼üÖظ´ÄØ£¬ÄѵÀҪȥ·ÖÎö×îÖÕ@@ERRORµÄÊýÖµ£¿ ÏÈselectÔÙinsert °ÑÕâÁ½¾ä·ÅÔÚÒ»¸ölock´úÂë¿éÖÐ ´æ´¢¹ý³ÌÀï²»ÐÐô£¿»òÕßʹÓÃGUID+Óû§Ãû×÷ΪÖ÷¼ü£¬¾Í²»»áÖظ´°É£¬ÏÔʾÓû§ÃûµÄʱºò´¦Àíһϡ£ ÔÚÓû§ÃûÖÐͨ¹ýajaxÒì²½²éѯÓû§ÃûÊÇ·ñ´æÔÚ °ÑÓû§ÃûÉèΪÖ÷¼ü, ºÇ ¿ÉÒÔ¶ÔÓû§ÃûÕâÒ»Áн¨Á¢Î¨Ò»ÐÔÔ¼Êø£¬unique ÔÙÓû§±íÉèÖÃÒ»¸öÖ÷¼ü Ö÷¼ü ÊÇunique ÀàÐÍ £¨È«ÇòΨһ±êʶ£© ¼ì²éËüµÄÖ÷¼üÊÇ·ñÒ»Ñù¾ÍÏ൱ÓÚ ¼ì²éÁË Óû§ÃûÁË unique ʹÓõÄʱºò Ö»ÒªÓà newid£¨£© ¾ÍOkÁË ÈçÌ⣬Óû§×¢²áʱ£¬Óû§ÃûÊDz»ÄÜÖظ´µÄ£¬ÈçºÎÅжϲåÈëµÄ¼Ç¼²»Öظ´ÄØ£¿ ¼ÓÖ÷¼ü,Óû§Ãû²»Öظ´¾ÍÖ±½Ó¼ÓÖ÷¼üÒýÓà ÈçÌ⣬Óû§×¢²áʱ£¬Óû§ÃûÊDz»ÄÜÖظ´µÄ£¬ÈçºÎÅжϲåÈëµÄ¼Ç¼²»Öظ´ÄØ£¿ Çë¿´Çå³þÎÒµÄÌâÄ¿£¬²»Òª´ÓÍøÉϳһЩ´ð°¸¹ýÀ´£¬ÍøÉϺܶàÈËдµÄÏÈselectÔÙinsertµÄ¶¼ÊÇϹ³¶£¬Ñ¹¸ù¾Íû¿¼Âǵ½²¢·¢ÐÔÎÊÌ⣬ÎÒÏÖÔÚ²»Ïë¼ÓÉÏÐòÁл¯¸ôÀ뼶±ð£¬ÓÐûÓкÃÒ»µãµÄ½â¾ö·½°¸ ÎÒÒªÇóÊä³ö@_Output INT Êä³ö´óÓÚÁã±íʾ
Ïà¹ØÎÊ´ð£º
±¾ÈËÒ»Ö±´ÓÊÂjavaµÄ¿ª·¢£¬ spring , strutsµÈµÈ£¬ ÏÖÔÚÂíÉÏÒª½ÓÒ»¸öasp.netµÄÏîÄ¿£¬ ²»ÖªµÀasp.netÖÐÓÐûÓкÍjavaÖеÄstrutsÀàËƵĶ«Î÷£¬ ¿ÉÒÔÔÚËûµÄ»ù´¡ÉÏ£¬Ö±½Ó¿ª·¢£¬ ЧÂʸߣ¬ ¶øÇÒºÃά»¤ ¡£¡£ лл£¬Ï£Íû´ó¼Ò£¬¶ ......
СµÜÊǽñÄê¸Õ±ÏҵѧÉúÕÒÁ˺ܳ¤Ê±¼ä¹¤×÷ÁË,×ÜÊÇʧ°Ü£¬Ò»Ð©¹«Ë¾¶¼ÒªÓй¤×÷¾ÑéµÄ£¬¶¼±ÀÀ£ÁË£¬ËùÒÔÏëÇë¸÷λ´ó¸ç°ï¸öæ ½ñÌìÎÒÈ¥ÃæÊÔÁËÒ»¼Ò¹«Ë¾£¬ËûÊÇÏë×öÒ»¸ö¡°Ò½ÁƵÄÍøÕ¾¡±Ï൱ÓÚÊÇÍƹã×Ô¼ºµÄÒ½ÁÆ·½·¨°É£¬Ëû½ÐÎ ......
¾²Ì¬Ä£°å£º <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/ ......
C# code: SqlConnection conn = CsDB.sqlcon(); SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......