Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚMSSQLÊý¾Ý¿â½ÇÉ«ÊôÐÔȨÏÞÑ¡ÔñÎÊÌâ



ÇëÎÊÔÚ¸³ÓèÊý¾Ý¿â½Çɫʱ£¬»áÓÐÕâ¸öȨÏÞÑ¡ÔñÃæ°å£¬Í¨³£MSSQLÀïÃæµÄ¿ò¿ò¶¼ÊÇ¿Õ×Å£¬Õâ¸öȨÏÞÑ¡Ôñ¿òÓÐÈýÖÖ״̬£¬
1¡¢¿Õ×Å
2¡¢Ñ¡ÖУ¬ÂÌÉ«µÄ¹´
3¡¢È¡Ïû£¬ºìÉ«µÄ²æ²æ¡£

Ñ¡ÖкÜÈÝÒ×Àí½â£¬µ«Èç¹û¶¼²»Ñ¡Ôñ£¬ÄÇô¿Õ×ŵĿò¿òÊDZíʾʲô£¿ÊǵÈͬÓÚÈ¡Ïû£¬»¹ÊÇÑ¡ÖУ¿»¹ÊÇĬÈÏÓÐÕâ¸öȨÏÞ£¿

лл£¡
È¡Ïû

¿ÕןÍXXÓ¦¸ÃÊÇÒ»¸öЧ¹û¡£

¿ÉÒÔ²»XX ¿Õ×ÅÒ»Ñù

È¡Ïû

ºÃÏñÒ²²»ÊÇ¡°È¡Ïû¡±µÄº¬Ò壬±ÈÈ磺
Ñ¡ÔñÒ»¸öÊý¾Ý¿â——Óû§——Ñ¡ÖÐÒ»¸öÊý¾Ý¿âËùÓÐÕßµÄÓû§Ãû——ÊôÐÔ——´ò¿ª¡°Êý¾Ý¿âÓû§ÊôÐÔÃæ°å¡±——Ñ¡Ôñdb_owner£¬ÔÙµã»÷¡°È¨ÏÞ¡±¡£
ÔÚµ¯³öµÄÓû§ÊôÐÔȨÏÞÃæ°åÉÏ£¬°ÑÆäÖеÄȨÏÞ¿ò½Óµ½ÏÂÃæÓû§±íÉÏ£¬ÆäÖеĿò¿òÒ²¶¼ÊÇ¿Õ×Å£¬µ«Õâ¸öÓû§¿ÉÒÔÖ´ÐÐselect £¬update , insert µÈÊÂÎñ£¬Õâ˵Ã÷¿ò¿òÈç¹ûÊÇ¿Õ×Å£¬ºÃÏñÊÇĬÈÏÓÐÕâЩȨÏÞ¡£

¸ãÔÎÁË¡£


¸Ðл¥ÉÏ£¬Ð»Ð»£¡


Ïà¹ØÎÊ´ð£º

mssqlÓï¾äµÄÎÊÌâ

Á½¸ö±í
±íA  UserID,Info1,Info2,¼°ÆäËû¼¸¸ö×Ö¶Î
±íB  UserID,Info1,Info2

±íAÀïÃæµÄÊý¾Ý£¬±íBÀïÃæ²»Ò»¶¨´æÔÚ
ÈçºÎÊä³öÕâÖÖ½á¹û

ÁÐ UserID,±íA Info1£¬±íA Info2£¬±íB Info1,±íB ......

ÉêÇëMSSQLÒÉÄÑÎÊÌâ°æ°æÖ÷,Ï£Íû´ó¼ÒÖ§³Ö!

»áÔ±ID£ºws_hgo
ÉêÇë°æÃæ£ºSQL ServerÒÉÄÑÎÊÌâ
ÉêÇë°æÖ÷ÀíÓÉ£ºÏ£ÍûÔÚCSDN¾¡¿ÉÄܵİïÖú´ó¼Ò,Ï£ÍûÄܹ»ºÍ´ó¼ÒÒ»ÆðÌá¸ßMSSQL¼¼Êõ
ƽ¾ùÉÏÍøÊ±¼ä(Сʱ/Ìì)£º>12Сʱ
ÊÇ·ñµ£Èιý±¾ÉçÇø»òÕ߯äËûÉçÇøÏà¹ØÖ ......

vb+mssql²éѯÎÊÌâ2

±ÈÈç
Ò»¸öÊÇÓû§Áбí
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 ......

MSSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞÖÆ

MYSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞÖÆÊÇ:GRANT ALL PRIVILEGES ON *.* TO username'@'IPµØÖ· IDENTIFIED BY 'ÃÜÂë ' WITH GRANT OPTION

ÓÐË­ÖªµÀÔÚMSSQLÖÐÔõôÉèÖÃIP·ÃÎÊÏÞÖÆ
ÒýÓÃ
MYSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞ ......

tadoqueryÔÚMSSQLÖÐÖ´Ðвéѯ£¬²ÎÊýÈçºÎ¸³Öµ£¿

ÈçÌ⣬²éѯÓï¾ä²ÎÊýÓ¦¸ÃÔõôд°¡£¿
¸ø²ÎÊý¸³Öµ¡¡ÔõôŪ°¡£¿

with Query do begin
  tempParam=parameters.addparameter;
  tempParam.name='@begindate';
  tempParam.Da ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ