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

MSSQLij×Ö¶ÎijЩÄÚÈÝÌæ»»

MSSQLij×Ö¶ÎijЩÄÚÈÝÌæ»»

ÀýÈç±í  S_ORDER  ,  ×ֶΠ NAME
                          AAA¾×asdfasd
                          ¾×aaaa
                          qwerqw¾×asdfasdf


ÒªÇóÌæ»»ºó½á¹ûÈçÏÂ: (°Ñ×Ö¶ÎÖаüº¬ÓÐ"¾×"×ÖµÄÈ«²¿Ìæ»»³É"×ì",µ«ÊÇÆäËüÄÚÈݲ»±ä)

                          AAA×ìasdfasd
                          ×ìaaaa
                          qwerqw×ìasdfasdf
         
SQL code:
UPDATE TB SET COL=REPLACE(COL,'¾×','×ì')


update tb set NAME=replcae(Name,'¾×','×ì')

SQL code:
update tb set col=raplace(col,'¾×','×ì')


SQL code:
update S_ORDER


Ïà¹ØÎÊ´ð£º

MSSQL$SQLEXPRESS ·þÎñÆô¶¯ÎÊÌâ

 


MSSQL$SQLEXPRESS  ÎÞ·¨Æô¶¯..  ÖªµÀÈçºÎ´¦ÀíµÄÇë°ï°ïæ  лл
¿´¿´´íÎóÈÕÖ¾

Ìáʾʲô´íÎó?

http://blog.csdn.net/fredrickhu/archive/2009/09/20/4573408.aspx
......

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

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

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

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

Èç¹ûÊǵϰ ......

ÈçºÎ½«excelÖеÄÊý¾Ýʵʱ±£´æÖÁmssqlÊý¾Ý¿â£¿

¼ÙÉèÓÐÁ½ÕÅ±í£¬t1 t2
t1:id ×Ö¶Î1 ×Ö¶Î2 ×Ö¶Î3
t2:id ×Ö¶Î4 ×Ö¶Î5 ×Ö¶Î6

ÏÖÓÃÒ»Ìõ²éѯÓï¾äselect t1.*,t2.* from t1,t2 where t1.id=t2.id and Ìõ¼þ¡­¡­
½«·ûºÏÌõ¼þµÄÊý¾Ý´ÓmssqlÊý¾Ý¿âÖе¼³öÖÁexce ......

ÈçºÎÔÚMSSQLÊý¾Ýµ¼ÈëµÄʱºòÓöÉÏ´íÎóÊý¾ÝÌø¹ý?

ÈçºÎÔÚMSSQLÊý¾Ýµ¼ÈëµÄʱºòÓöÉÏ´íÎóÊý¾ÝÌø¹ý?
Õâ¸ö£¿ÄÇÄ㻹ÊÇÓÃssis°É¡£Êý¾Ýµ¼Èëµ¼³öûÓпØÖÆÁ÷

ÊÇ2000µÄÊý¾Ý¿â

2000ûʲôºÃµÄ°ì·¨

ÓÐûÓÐÆäËüµÄµ¼È빤¾ßÄØ?

×Ô¼ºÔÚǰ̨д´úÂëÅжϡ£

·¹ý£¬ÓÃÇ°Ì¨Ê ......

mssql ¶à±í²éѯµÄÎÊÌâ

ÇëÎÊ£ºÔÚ¶à±í²éѯÖУ¬²éѯ²»Í¬±íÖеĶà¸ö×ֶΣ¬ÆäÖÐÓÐЩ×ֶΰüÀ¨º¯Êý£¬¶àл¸÷λ´óÏÀÖ¸µãÃÔ½ò°¡£¡£¡£¡
±í1
¹¤ºÅ    ÐÕÃû
1      Ëν­
2      ¬¿¡Òå

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