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

ΪʲôMSSQLÖеÄGUIDÀàÐÍÓÐÁ½¸ö{}µÄ¡£²»·½±ã°¡¡£

ΪʲôMSSQLÖеÄGUIDÀàÐÍÓÐÁ½¸ö{xxxxxx}µÄ¡£²»·½±ã°¡¡£

µØÖ·´«ÖµµÄʱºòÕâÑùºÃ²»ºÃµÄ£¿

ĬÈÏÊä³öP¸ñʽ
-----------
ĬÈÏÊä³öÊÇB¸ñʽ...

ÉÏÃæËµÁË È¡³öÀ´¸ñʽ»¯Ò»ÏÂ

ѧϰÁË.

ÒýÓÃ
ĬÈÏÊä³öP¸ñʽ
-----------
ĬÈÏÊä³öÊÇB¸ñʽ...


µ«ÊÇÓÃC#È¡³öÀ´£¬Ò²ÓС°£û£ý¡±Õâ¸ö´óÀ¨ºÅ£¿

ÊÇûÓУ¬¸ã´í¡£ÔÚÊý¾Ý¿âÖп´µÃµ½¡£ºÇºÇ¡£¶àлÁË£¡£¡£¡

ÔÚ²éѯµÄʱºò¼Ó²»¼Ó{}¶¼ÄܲéµÄµ½
select * from tb where GUID='{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}'
select * from tb where GUID='xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'
²é³öÀ´µÄ½á¹ûÓ¦¸ÃÒ»ÑùµÄ



Ïà¹ØÎÊ´ð£º

asp+mssqlͳ¼ÆÎÊÌâ

asp+mssql ¸ÃÈçºÎ·µ»ØÈçÏÂÐÅÏ¢ÄØ
±ÈÈçÒ»¸ö±íÀïÃæµÄÊý¾Ý
date              info
2009-1-1 13:00:00 12345
2009-1-1 13:00:01 12345
2009-1-1 13:00:02 12345
......

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(×Ö¶Î)
------------------------È ......

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



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

Ñ¡ÖкÜÈÝÒ×Àí½â£¬µ«Èç¹û¶¼²» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ