MSSQLÈçºÎ²åÈë²»ÏàͬµÄ¼Ç¼ - .NET¼¼Êõ / ASP.NET
ÈçÌ⣬Óû§×¢²áʱ£¬Óû§ÃûÊDz»ÄÜÖظ´µÄ£¬ÈçºÎÅжϲåÈëµÄ¼Ç¼²»Öظ´ÄØ£¿
Çë¿´Çå³þÎÒµÄÌâÄ¿£¬²»Òª´ÓÍøÉϳһЩ´ð°¸¹ýÀ´£¬ÍøÉϺܶàÈËдµÄÏÈselectÔÙinsertµÄ¶¼ÊÇϹ³¶£¬Ñ¹¸ù¾Íû¿¼Âǵ½²¢·¢ÐÔÎÊÌ⣬ÎÒÏÖÔÚ²»Ïë¼ÓÉÏÐòÁл¯¸ôÀ뼶±ð£¬ÓÐûÓкÃÒ»µãµÄ½â¾ö·½°¸
ÎÒÒªÇóÊä³ö@_Output INT
Êä³ö´óÓÚÁã±íʾ@@IDENTITY
µÈÓÚ0±íʾ´æÔÚÏàͬ¼Ç¼
µÈÓÚ¸ºÊý±íʾ·¢Éú´íÎó¡£
°ÑÓû§ÃûÉèÖÃΪÖ÷¼ü»òÕßÊÇΨһµÄ£¬ÕâÑù²åÈëÒ»Ñù¾Í»á±¨´í£¬±£Ö¤²»»áÓÐÒ»ÑùµÄͬÑùµÄÊý¾Ý²åÈë
Êǵģ¬Í¨¹ý@@ERRORȷʵ¿ÉÒԵõ½´íÎóÁË£¬
µ«ÈçºÎÅж¨Ò»¶¨ÊÇÒòΪÖ÷¼üÖظ´ÄØ£¬ÄѵÀҪȥ·ÖÎö×îÖÕ@@ERRORµÄÊýÖµ£¿
ÏÈselectÔÙinsert
°ÑÕâÁ½¾ä·ÅÔÚÒ»¸ölock´úÂë¿éÖÐ
´æ´¢¹ý³ÌÀï²»ÐÐô£¿»òÕßʹÓÃGUID+Óû§Ãû×÷ΪÖ÷¼ü£¬¾Í²»»áÖظ´°É£¬ÏÔʾÓû§ÃûµÄʱºò´¦Àíһϡ£
ÔÚÓû§ÃûÖÐͨ¹ýajaxÒì²½²éѯÓû§ÃûÊÇ·ñ´æÔÚ
°ÑÓû§ÃûÉèΪÖ÷¼ü,
ºÇ
¿ÉÒÔ¶ÔÓû§ÃûÕâÒ»Áн¨Á¢Î¨Ò»ÐÔÔ¼Êø£¬unique
ÔÙÓû§±íÉèÖÃÒ»¸öÖ÷¼ü
Ö÷¼ü ÊÇunique ÀàÐÍ £¨È«ÇòΨһ±êʶ£©
¼ì²éËüµÄÖ÷¼üÊÇ·ñÒ»Ñù¾ÍÏ൱ÓÚ ¼ì²éÁË Óû§ÃûÁË
unique ʹÓõÄʱºò Ö»ÒªÓà newid£¨£© ¾ÍOkÁË
ÈçÌ⣬Óû§×¢²áʱ£¬Óû§ÃûÊDz»ÄÜÖظ´µÄ£¬ÈçºÎÅжϲåÈëµÄ¼Ç¼²»Öظ´ÄØ£¿
¼ÓÖ÷¼ü,Óû§Ãû²»Öظ´¾ÍÖ±½Ó¼ÓÖ÷¼ü
Ïà¹ØÎÊ´ð£º
±¾ÈËÒ»Ö±´ÓÊÂjavaµÄ¿ª·¢£¬ spring , strutsµÈµÈ£¬ ÏÖÔÚÂíÉÏÒª½ÓÒ»¸öasp.netµÄÏîÄ¿£¬ ²»ÖªµÀasp.netÖÐÓÐûÓкÍjavaÖеÄstrutsÀàËƵĶ«Î÷£¬ ¿ÉÒÔÔÚËûµÄ»ù´¡ÉÏ£¬Ö±½Ó¿ª·¢£¬ ЧÂʸߣ¬ ¶øÇÒºÃά»¤ ¡£¡£ лл£¬Ï£Íû´ó¼Ò£¬¶ ......
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......