Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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'
²é³öÀ´µÄ½á¹ûÓ¦¸ÃÒ»ÑùµÄ



Ïà¹ØÎÊ´ð£º

mssql job²»ÄÜÖ´ÐÐ

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

¡¾Ï뿼¸öMSSQLÈÏÖ¤-×Éѯ¡¿

RT
ºÃÏñ¿¼MSSQLÖ¤·ÖºÃ¼¸ÖÖŶ?
×ÉѯÏ ÓÐʲôÏà¹Ø×ÊÁÏô£¿

Õâ¸öÕæ²»Çå³þ£¬°ï¶¥°É

µ±È»ÊÇMICROSOFTµÄMCSEÁË

..

°ï¶¥

°ï¶¥Ï°ɡ£¡£

MS SQL ÈÏÖ¤
2000:mcdba
2005:·ÖÈý¸öϵÁР ¹ ......

mssql ÈçºÎÍêÕûµÄµ¼Èë±í½á¹¹

¸÷λ´óÏÀ£¬ÔÚsql server2000 ÖУ¬ÈçºÎµ¼Èë±í£¬ËûÀïÃæµÄ½á¹¹¶¼²»·¢Éú±ä»¯£¬ÏñË÷Òý£¬Ö÷¼üµÈ»¹ÊÇÔ­À´±íÀïµÄÉèÖã¬Èç¹ûÉú³Ésql½Å±¾µÄ»°£¬ÔÚ²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐÒ»´Î£¬Ö÷¼üË÷Òý¶¼Ã»ÁË£¬ÓÐûÓкõİ취
±¸·Ý»¹Ô­»òÕ߸½¼ÓÊÇΨ ......

C++ Á¬½ÓÊý¾Ý¿â MSSQL Ö±½ÓÊäIPºÍ¶Ë¿Ú Á¬½Ó²»ÉÏ

_RecordsetPtr      pRs("ADODB.Recordset");
"provider=SQLOLEDB;Data Source=»úÆ÷Ãû\\SQLEXPRESS;Persist  Security  Info=False;User ID=sa;PWD=sa;initial catalog ......

mssql ÀïµÄsystem_user ÔÚoracleÀïÓÐʲôµÈ¼Ûº¯Êý£¿

mssql ÀïµÄsystem_user ÔÚoracleÀïÓÐʲôµÈ¼Ûº¯Êý£¿
system_userÊä³öÊǵÄʲô£¿

µ±Ç°²Ù×÷µÄÓû§£¬ÄãÓÃʲôµÇ¼SQL Query Analyzer ¾ÍÊÇʲô

²»Á˽âmsqsl£¬Õâ¸öº¯ÊýÊÇÈ¡µ±Ç°Á¬½ÓuserµÄÂð£¿

Èç¹ûÊǵĻ° ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ