Ϊʲô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' ²é³öÀ´µÄ½á¹ûÓ¦¸ÃÒ»ÑùµÄ
Ïà¹ØÎÊ´ð£º
Ôõô»¹Ã»³öÀ´£¿£¿ ËÔÚ͵ÀÁÂð£¿! Íê±Ï¡£ 1 SF 3 bd ûÁË 00 還ÒÔ為ÊÇÐÂ聞~~ ÒýÓà 還ÒÔ為ÊÇÐÂ聞~~ w ... .. ÒýÓà ű ......
»áÔ±ID£ºws_hgo ÉêÇë°æÃæ£ºSQL ServerÒÉÄÑÎÊÌâ ÉêÇë°æÖ÷ÀíÓÉ£ºÏ£ÍûÔÚCSDN¾¡¿ÉÄܵİïÖú´ó¼Ò,Ï£ÍûÄܹ»ºÍ´ó¼ÒÒ»ÆðÌá¸ßMSSQL¼¼Êõ ƽ¾ùÉÏÍøÊ±¼ä(Сʱ/Ìì)£º>12Сʱ ÊÇ·ñµ£Èιý±¾ÉçÇø»òÕ߯äËûÉçÇøÏà¹ØÖ ......
¸÷λ´óÏÀ £¬ÎÒ½ñÌì×öÁ˸öjob£¬sqlÊÇ exec proc_showresult. ¿É¾ÍÊDz»ÄÜÖ´ÐÐ £¬È»ºóÎÒ°ÉÕâ¸ösql»»³É select 1¡£¾ÍûÎÊÌ⣬ÕâÊÇʲôÔÒò°¡ Çë¸ßÊÖÖ¸½Ì ´æ´¢¹ý³ÌÓвÎÊýû?? Ò²ÐíÊÇÖ´ÐÐÁË,Äãû ......
ÔÚms sqlserverÖУ¬È¡Âú×ãÌõ¼þµÄǰ¼¸ÐпÉÒÔʹÓÃselect topÓï¾ä£¬µ«ÔÚoracleÖв¢Ã»ÓÐÕâÑùµÄÓï¾ä£¬ ÎÒ´ÓÍøÉÏ¿´µ½ÁËÒ»ÖÖʵÏÖ select * (select * from talbename) where rownum <=100 order by rownum as ......