Óû§saµÇ¼ʧ°Ü,¸ÃÓû§Óë¿ÉÐÅsql serverÁ¬½ÓÎÞ¹ØÁª
½ñÌì²âÊÔwebÏîĿн¨ÁËÒ»¸öÊý¾Ý¿â£¬½á¹û±¨´í,ÒÔÇ°µÇ¼ֱ½ÓÑ¡Ôñ'WindowsÉí·ÝÑéÖ¤',²¢Ã»ÓÐʲôÎÊÌâ³öÏÖ!¿ÉÇ°¶Îʱ¼ä²ÉÓÃ'SQLSERVERÉí·ÝÑéÖ¤'È¥µÇ¼,ËæÖ®µÄÎÊÌâ¾ÍÀ´ÁË.ÎÞÂÛÓÃʲô·½·¨¾ÍÊÇÒ»¸ö½á¹û³ö´í! ³ö´íµÄÔÒòÊÇ:'Óû§ 'sa' µÇ¼ʧ°Ü¡£¸ÃÓû§Óë¿ÉÐÅ SQL Server Á¬½ÓÎÞ¹ØÁª'.½ñÌìÉÏÍøÉϲéÁË°ëÌ컹ÊǸ㲻¶¨,×îºó¾¹ýÍøÉϺÍÊéÉϵĻã×Ü,ÖÕÓڸ㶨ÁË!ºÇºÇ········/// ¾ßÌåµÄ·½·¨ÊÇ£º ¡¡¡¡1£º´ò¿ªSQL Server Manager¹ÜÀíÆ÷£¡ÔÚ×óÃæÕÒµ½ ‘°²È«ÐÔ’ µ¥»÷ÓÒ¼ü Ñ¡Ôñ‘н¨”£¬“µÇ¼” µ¯³öÒ»¸ö¶Ô»°¿ò£¬ÔڵǼÃûÖÐÊäÈëÄãµÄµÇ¼ºÅ£¬Ñ¡Ôñ'SQLSERVERÉí·ÝÑéÖ¤'£¬²¢ÊäÈëÃÜÂ룬¿ÉÒÔ°Ñ‘Óû§Ï´εǼʱ±ØÐëÐÞ¸ÄÃÜÂë’È¡Ïûµô¡£ µã»÷‘Óû§Ó³Éä’£¬ÔÚÓÒÃæÑ¡ÔñÒªÓ³ÉäµÄÊý¾Ý¿â£¬²¢ÔÚÇ°Ãæ´ò¹´£¡ÔÚÏÂÃæÒ»À¸ÖБdb-owner’ºÍ‘public’Ç°Ãæ´ò¹´¡£È»ºóµã»÷£§×´Ì¬£§ÔÚÓÒÃæÀ¸ÖÐÑ¡ÖУ¢ÊÚÓ裢¡¢“ÆôÓÔ£¬ÕâÁ½ÏîÒ»°ãÊÇĬÈϵģ¬µ«Èç¹ûĬÈϵIJ»ÊÇ´ËÁ½Ïî±ØÐë¸Ä¹ýÀ´£¬²»È»ÊÇÁ¬²»Éϵģ¡µã»÷‘È·¶¨’¡£ 2£ºÕÒµ½SQL·þÎñÆ÷£¬ÔÚ×óÀ¸ÖÐÉÏÃ棬µ¥»÷ÓÒ¼ü£¬ÔÚµ¯³öµÄ²Ëµ¥ÖÐÑ¡Ôñ“ÊôÐÔ”ÃüÁî¡£µ¯³öÒ»¸ö¶Ô»°¿ò£¬µ¥»÷“°²È«ÐÔ”£¬ÔÚ“·þÎñÆ÷Éí·ÝÑéÖ¤”ÏÂÃæÑ¡Ôñ“SQL SERVERºÍWINDOWSÉí·ÝÑé֤ģʽ”£¬ÔÚÇ°Ãæ´ò¹´£¡¼ÇµÃÕâÒ»²½ºÜÖØÒª£¬Èç¹ûûÓÐÕâÒ»²½Äã¾Í±ðÏëµÇ¼³É¹¦£¡È»ºóµ¥»÷“È·¶¨”¾Í¿ÉÒÔÁË£¡ 3£ºÖØÐÂÆô¶¯·þÎñ¾Í¿ÉÒÔÑ¡ÔñSQL SERVER Éí·ÝÑé֤ģʽµÇ¼ÁË£¡ÊäÈë¸Õ²ÅµÄÓû§ÃûºÍÃÜÂë¾Í¿ÉÒԵǼ³É¹¦ÁË£¡
Ïà¹ØÎĵµ£º
Èç¹û£¬ÏÖÔÚÓÐÁ½ÕűíA(id,xx.xx...),C(id,Cid,xx,xx...)£¬Ô¤ÊµÏÖCÖеÄidÓëA ÖÐid¼¶ÁªÉ¾³ý¡¢¼¶Áª¸üÐÂ/Êý¾Ýͬ²½£¬¿ÉÓÐÁ½ÖÖʵÏÖ·½Ê½£º
Ò».
ÀûÓÃsql server×Ô´øµÄ¼¶ÁªÉ¾³ý¡¢¼¶Áª¸üй¦ÄÜ£¬¼´ÆäÍâ¼üÔ¼Êø;¾¶
alter table dbo.C
add constraint FK_C_A_AID
foreign key(AID) references dbo.A(AID)
on delet ......
Update Channel set Unit ='mg' ,
RunUpThreshold='10' ,
RunDownThreshold='10' ,
SafetyUpThreshold='10' ,
SafetyDownThreshold='10'
where Bridge='001' and DeviceCode='AS'
and SensorCode='001' and Supplement='N'
set £º ','
where: and ......
»Ö¸´Ä£Ê½ÊÇÊý¾Ý¿âµÄÒ»ÖÖÌØÐÔ,Ëü¿ØÖÆ×ÅÊý¾Ý¿â±¸·ÝºÍ»¹ÔµÄ»ù±¾ÐÐΪ.
sql server ÌṩÁËÈýÖÖ»Ö¸´Ä£Ê½,ËûÃǾö¶¨ÁËÓжàÉÙºÍʲôÑùµÄÊý¾Ý¿ÉÒÔ±»±¸·ÝÏÂÀ´.
1.¼òµ¥»Ö¸´Ä£Ê½
Ö÷ÒªÓ¦ÓÃÓÚСÐÍÊý¾Ý¿âºÍ²»¾³£¸Ä±äµÄÊý¾Ý
2.ÍêÕû»Ö¸´Ä£Ê½
¿ÉÒÔÔÚ×î´ó·¶Î§ÄÚ·ÀÖ¹³öÏÖ¹ÊÕÏʱ¶ªÊ§Êý¾Ý,Ëü°üÀ¨Êý¾Ý¿â±¸·ÝºÍʳÎïÈÕÖ¾±¸·Ý,²¢Ìá¹ ......
PL/SQL-FOR UPDATE Óë FOR UPDATE OFµÄÇø±ð
url:http://hi.baidu.com/1413/blog/item/a521251f7e5993c4a686696b.html
Êý¾Ý¿â oracle for update of ºÍ for updateÇø±ð
select * from TTable1 for update Ëø¶¨±íµÄËùÓÐÐУ¬Ö»ÄܶÁ²»ÄÜд
2 select * from TTable1 wher ......