Ϊʲô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' ²é³öÀ´µÄ½á¹ûÓ¦¸ÃÒ»ÑùµÄ
Ïà¹ØÎÊ´ð£º
¸÷λ´óÏÀ £¬ÎÒ½ñÌì×öÁ˸öjob£¬sqlÊÇ exec proc_showresult. ¿É¾ÍÊDz»ÄÜÖ´ÐÐ £¬È»ºóÎÒ°ÉÕâ¸ösql»»³É select 1¡£¾ÍûÎÊÌ⣬ÕâÊÇʲôÔÒò°¡ Çë¸ßÊÖÖ¸½Ì ´æ´¢¹ý³ÌÓвÎÊýû?? Ò²ÐíÊÇÖ´ÐÐÁË,Äãû ......
RT ºÃÏñ¿¼MSSQLÖ¤·ÖºÃ¼¸ÖÖŶ? ×ÉѯÏ ÓÐʲôÏà¹Ø×ÊÁÏô£¿ Õâ¸öÕæ²»Çå³þ£¬°ï¶¥°É µ±È»ÊÇMICROSOFTµÄMCSEÁË .. °ï¶¥ °ï¶¥Ï°ɡ£¡£ MS SQL ÈÏÖ¤ 2000:mcdba 2005:·ÖÈý¸öϵÁÐ ¹ ......
¸÷λ´óÏÀ£¬ÔÚsql server2000 ÖУ¬ÈçºÎµ¼Èë±í£¬ËûÀïÃæµÄ½á¹¹¶¼²»·¢Éú±ä»¯£¬ÏñË÷Òý£¬Ö÷¼üµÈ»¹ÊÇÔÀ´±íÀïµÄÉèÖã¬Èç¹ûÉú³Ésql½Å±¾µÄ»°£¬ÔÚ²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐÒ»´Î£¬Ö÷¼üË÷Òý¶¼Ã»ÁË£¬ÓÐûÓкõİ취 ±¸·Ý»¹Ô»òÕ߸½¼ÓÊÇΨ ......
_RecordsetPtr pRs("ADODB.Recordset"); "provider=SQLOLEDB;Data Source=»úÆ÷Ãû\\SQLEXPRESS;Persist Security Info=False;User ID=sa;PWD=sa;initial catalog ......
mssql ÀïµÄsystem_user ÔÚoracleÀïÓÐʲôµÈ¼Ûº¯Êý£¿ system_userÊä³öÊǵÄʲô£¿ µ±Ç°²Ù×÷µÄÓû§£¬ÄãÓÃʲôµÇ¼SQL Query Analyzer ¾ÍÊÇʲô ²»Á˽âmsqsl£¬Õâ¸öº¯ÊýÊÇÈ¡µ±Ç°Á¬½ÓuserµÄÂ𣿠Èç¹ûÊǵĻ° ......