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
Ïà¹ØÎÊ´ð£º
ÔÊý¾Ý----------------------------
a b
49 ƤÊéϵÁÐ
50 ¾¼Ã ......
ÉÌÆ·±í
ProductManager_Name ProductManager_Type_Id
-------------------------------------------------------------
Öйú¾¼ÃÈȵãÑо¿ ......
@str = |108||203|
²éÕÒ·µ»Ø½á¹ûstr = 108 Ö»·µ»ØµÚÒ»¸ö ÆäËüµÄ¶¼¸Éµô
SQL code:
declare @str varchar(100)
set @str = '|108||203|'
select substring(@str,2,charindex('|',stuff(@str,1,1,''))-1)
......
ÇëÎÊ£ºÔÚ¶à±í²éѯÖУ¬²éѯ²»Í¬±íÖеĶà¸ö×ֶΣ¬ÆäÖÐÓÐЩ×ֶΰüÀ¨º¯Êý£¬¶àл¸÷λ´óÏÀÖ¸µãÃÔ½ò°¡£¡£¡£¡
±í1
¹¤ºÅ ÐÕÃû
1 Ëν
2 ¬¿¡Òå
± ......
ÏÖÔÚÁ¬µÄÒ»Ô¶³Ìmssql£¬Ã¿´Î²éѯ±È½ÏÂý£¬ÏÖÔÚÏëһϰÑËùÓмǼ²éѯ³öÀ´ÓÃÊý¾Ý¼¯±£´æÆðÀ´£¬È»ºóÕë¶ÔÊý¾Ý¼¯Ôٴβéѯɸѡ¡£
ÏÖÔÚÎÊÏÂÄǸöÊý¾Ý¼¯ÈçºÎ±£´æ²éѯ¼Ç¼£¬¶øÔٴβéѯ£¬¶àлÁË¡£
¿ÉÒÔ°ÑÊý¾Ý¼¯ÖеÄÊý¾Ý·Åµ½ÄÚ´ ......