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

ÍøÕ¾´ò°ü£¬ÄÜ´ò³ÉmssqlµÄ±í²»Èÿͻ§¿´µ½ÄÚÈÝÂð

ÈçÌ⣬Ï뽫ÎÒÒÔǰ×ö¹ýµÄÍøÕ¾·ÅÔÚÍøÉϸøÈË¿´£¬ÓÉÓÚÊÇms sqlµÄ£¬´ó¶àÊýÍøÂçÉ̵ÄÐéÄâÖ÷»úÊÇÒªÊշѵģ¬
Ïë´ò°üºó·ÅÔÚһЩÃâ·ÑµÄ¿Õ¼ä£¬ÈÃÈ˼Ò×Ô¼ºÏÂÔØÈ¥¿´£¬ËùÒÔÏ£Íû´ò¹ý°üºóµÄÊý¾Ý¿âµÄ±í²»Èÿͻ§¿´µ½£¬
»òÕßÊǼӹýÃܵÄ
ÄÄλ¸ßÊÖÖ¸µãÒ»ÏÂ



sqlserverµÄÊý¾Ý¿â´ò°ü?Èç¹ûÊÇaccesseÖ®À۵ıȽϼòµ¥ ¸Ä¸ömdb¼´¿É,mssqlserver?

Â¥Ö÷µÄÒâ˼ÊÇʲôѽ£¡ÓÖ¿ÉÒÔ¿´£¬ÓÖ²»¿ÉÒÔ¿´£¡

Êý¾Ý¿â¼ÓÃÜ£¿£¿
http://blog.csdn.net/fredrickhu/archive/2009/09/20/4574249.aspx

ÕâÑùµÄÂð£¿

×Ô¼ºÓÃǰ̨ӦÓóÌÐòÖ´ÐÐÄãµÄ½¨±íÎļþ¡¡£¬ÄãµÄÎļþ¼ÓÃܵķ½Ê½¶àÁË£¬¿ÉÒÔwinrar¡¡£¬ÕâÑù¸øÓû§ÏÂÀ´µÄÊÇÒ»¸ö¿ÉÖ´ÐÐÎļþ£¨ÄÜÅäÖÃÁ¬½ÓµÄÊý¾Ý¿âµÈ²ÎÊý£©»òÒ»¸ö¼ÓÃܵĽ¨±íÎļþ



¼ÓÃܾͿÉÒÔ½â¾öÁË

4Â¥¡¢5Â¥ÄÜ·ñÔÙ˵ÏêÏ¸Ð©ÄØ£¬ÄãÃǵķ½·¨Ã»Óùý


Ïà¹ØÎÊ´ð£º

mssqlÓï¾äµÄÎÊÌâ

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

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

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

vb+mssql²éѯÎÊÌâ

±ÈÈç
Ò»¸öÊÇÓû§Áбí
UserID
1
2
3
4

Ò»¸öÊÇ´ÎÊýÁбí(ÿÌì·ÃÎÊÒ»´ÎNum+1)
UserID Day Num
1 2009-09-22  10
2 2009-09-22  20
4 2009-09-22  8
......

mssql job²»ÄÜÖ´ÐÐ

¸÷λ´óÏÀ  £¬ÎÒ½ñÌì×öÁ˸öjob£¬sqlÊÇ exec  proc_showresult.
¿É¾ÍÊDz»ÄÜÖ´ÐÐ £¬È»ºóÎÒ°ÉÕâ¸ösql»»³É select 1¡£¾ÍûÎÊÌ⣬ÕâÊÇʲôԭÒò°¡  Çë¸ßÊÖÖ¸½Ì
´æ´¢¹ý³ÌÓвÎÊýû??
Ò²ÐíÊÇÖ´ÐÐÁË,Äãû ......

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

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

with Query do begin
  tempParam=parameters.addparameter;
  tempParam.name='@begindate';
  tempParam.Da ......

Çë½Ì¸ßÊÖMSSQLÈ¥¿Õ¸ñÎÊÌ⣿THK£¡

Çë¿´ÒÔÏÂÀý×Ó Ð»Ð»£¡
Àý×Ó

    A(×Ö¶Î)
------------------------
a b  c
ab  c
f c d


½á¹û:

    A(×Ö¶Î)
------------------------È ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ