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 ÎÞ·¨Æô¶¯.. ÖªµÀÈçºÎ´¦ÀíµÄÇë°ï°ïæ лл
¿´¿´´íÎóÈÕÖ¾
Ìáʾʲô´íÎó?
http://blog.csdn.net/fredrickhu/archive/2009/09/20/4573408.aspx
......
mssql ÀïµÄsystem_user ÔÚoracleÀïÓÐʲôµÈ¼Ûº¯Êý£¿
system_userÊä³öÊǵÄʲô£¿
µ±Ç°²Ù×÷µÄÓû§£¬ÄãÓÃʲôµÇ¼SQL Query Analyzer ¾ÍÊÇʲô
²»Á˽âmsqsl£¬Õâ¸öº¯ÊýÊÇÈ¡µ±Ç°Á¬½ÓuserµÄÂð£¿
Èç¹ûÊǵϰ ......
¼ÙÉèÓÐÁ½ÕÅ±í£¬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Êý¾Ýµ¼ÈëµÄʱºòÓöÉÏ´íÎóÊý¾ÝÌø¹ý?
Õâ¸ö£¿ÄÇÄ㻹ÊÇÓÃssis°É¡£Êý¾Ýµ¼Èëµ¼³öûÓпØÖÆÁ÷
ÊÇ2000µÄÊý¾Ý¿â
2000ûʲôºÃµÄ°ì·¨
ÓÐûÓÐÆäËüµÄµ¼È빤¾ßÄØ?
×Ô¼ºÔÚǰ̨д´úÂëÅжϡ£
·¹ý£¬ÓÃÇ°Ì¨Ê ......
ÇëÎÊ£ºÔÚ¶à±í²éѯÖУ¬²éѯ²»Í¬±íÖеĶà¸ö×ֶΣ¬ÆäÖÐÓÐЩ×ֶΰüÀ¨º¯Êý£¬¶àл¸÷λ´óÏÀÖ¸µãÃÔ½ò°¡£¡£¡£¡
±í1
¹¤ºÅ ÐÕÃû
1 Ëν
2 ¬¿¡Òå
± ......