¹ØÓÚMSSQLÊý¾Ý¿â½ÇÉ«ÊôÐÔȨÏÞÑ¡ÔñÎÊÌâ
ÇëÎÊÔÚ¸³ÓèÊý¾Ý¿â½Çɫʱ£¬»áÓÐÕâ¸öȨÏÞÑ¡ÔñÃæ°å£¬Í¨³£MSSQLÀïÃæµÄ¿ò¿ò¶¼ÊÇ¿Õ×Å£¬Õâ¸öȨÏÞÑ¡Ôñ¿òÓÐÈýÖÖ״̬£¬
1¡¢¿Õ×Å
2¡¢Ñ¡ÖУ¬ÂÌÉ«µÄ¹´
3¡¢È¡Ïû£¬ºìÉ«µÄ²æ²æ¡£
Ñ¡ÖкÜÈÝÒ×Àí½â£¬µ«Èç¹û¶¼²»Ñ¡Ôñ£¬ÄÇô¿Õ×ŵĿò¿òÊDZíʾʲô£¿ÊǵÈͬÓÚÈ¡Ïû£¬»¹ÊÇÑ¡ÖУ¿»¹ÊÇĬÈÏÓÐÕâ¸öȨÏÞ£¿
лл£¡
È¡Ïû
¿ÕןÍXXÓ¦¸ÃÊÇÒ»¸öЧ¹û¡£
¿ÉÒÔ²»XX ¿Õ×ÅÒ»Ñù
È¡Ïû
ºÃÏñÒ²²»ÊÇ¡°È¡Ïû¡±µÄº¬Ò壬±ÈÈ磺
Ñ¡ÔñÒ»¸öÊý¾Ý¿â——Óû§——Ñ¡ÖÐÒ»¸öÊý¾Ý¿âËùÓÐÕßµÄÓû§Ãû——ÊôÐÔ——´ò¿ª¡°Êý¾Ý¿âÓû§ÊôÐÔÃæ°å¡±——Ñ¡Ôñdb_owner£¬ÔÙµã»÷¡°È¨ÏÞ¡±¡£
ÔÚµ¯³öµÄÓû§ÊôÐÔȨÏÞÃæ°åÉÏ£¬°ÑÆäÖеÄȨÏÞ¿ò½Óµ½ÏÂÃæÓû§±íÉÏ£¬ÆäÖеĿò¿òÒ²¶¼ÊÇ¿Õ×Å£¬µ«Õâ¸öÓû§¿ÉÒÔÖ´ÐÐselect £¬update , insert µÈÊÂÎñ£¬Õâ˵Ã÷¿ò¿òÈç¹ûÊÇ¿Õ×Å£¬ºÃÏñÊÇĬÈÏÓÐÕâЩȨÏÞ¡£
¸ãÔÎÁË¡£
¸Ðл¥ÉÏ£¬Ð»Ð»£¡
Ïà¹ØÎÊ´ð£º
Á½¸ö±í
±íA UserID,Info1,Info2,¼°ÆäËû¼¸¸ö×Ö¶Î
±íB UserID,Info1,Info2
±íAÀïÃæµÄÊý¾Ý£¬±íBÀïÃæ²»Ò»¶¨´æÔÚ
ÈçºÎÊä³öÕâÖÖ½á¹û
ÁÐ UserID,±íA Info1£¬±íA Info2£¬±íB Info1,±íB ......
»áÔ±ID£ºws_hgo
ÉêÇë°æÃæ£ºSQL ServerÒÉÄÑÎÊÌâ
ÉêÇë°æÖ÷ÀíÓÉ£ºÏ£ÍûÔÚCSDN¾¡¿ÉÄܵİïÖú´ó¼Ò,Ï£ÍûÄܹ»ºÍ´ó¼ÒÒ»ÆðÌá¸ßMSSQL¼¼Êõ
ƽ¾ùÉÏÍøÊ±¼ä(Сʱ/Ìì)£º>12Сʱ
ÊÇ·ñµ£Èιý±¾ÉçÇø»òÕ߯äËûÉçÇøÏà¹ØÖ ......
±ÈÈç
Ò»¸öÊÇÓû§Áбí
UserID
1
2
3
4
Ò»¸öÊǼǼÁбí(ÿ¸öÓû§Ò»Ìì¿ÉÄÜÓжàÌõÊý¾Ý)
UserID Day
1 2009-09-22
1 2009-09-22
1 2009-09-22
2 2009-09-22
2 20 ......
MYSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞÖÆÊÇ:GRANT ALL PRIVILEGES ON *.* TO username'@'IPµØÖ· IDENTIFIED BY 'ÃÜÂë ' WITH GRANT OPTION
ÓÐËÖªµÀÔÚMSSQLÖÐÔõôÉèÖÃIP·ÃÎÊÏÞÖÆ
ÒýÓÃ
MYSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞ ......
ÈçÌ⣬²éѯÓï¾ä²ÎÊýÓ¦¸ÃÔõôд°¡£¿
¸ø²ÎÊý¸³Öµ¡¡ÔõôŪ°¡£¿
with Query do begin
tempParam=parameters.addparameter;
tempParam.name='@begindate';
tempParam.Da ......