Çë½Ì¸ßÊÖMSSQLÈ¥¿Õ¸ñÎÊÌ⣿THK£¡

Çë¿´ÒÔÏÂÀý×Ó Ð»Ð»£¡
Àý×Ó

    A(×Ö¶Î)
------------------------
a b  c
ab  c
f c d


½á¹û:

    A(×Ö¶Î)
------------------------È¥µôËùÓеĿոñÖ»Áô×Ö·û
abc
abc
fcd

---

replace(a,' ','')

---

SQL code:
update a set a=replace(a,char(32),'')

---

SQL code:
SELECT
A,REPLACE(A,' ','')
from TB

---

SQL code:

update tb
set A=replace(A,' ','')




??

---

SQL code:
--> Éú³É²âÊÔÊý¾Ý±í:tb

IF NOT OBJECT_ID('[tb]') IS NULL
DROP TABLE [tb]
GO
CREATE TABLE [tb]([A] NVARCHAR(10))
INSERT [tb]
SELECT 'a b c' UNION ALL
SELECT 'ab c ' UNION ALL
SELECT 'f c d '
GO
--SELECT * from [tb]

-->SQL²éѯÈçÏÂ:
UPDATE tb SET
a=REPLACE(a,CHAR(32),'')

SELECT * from tb
/*
A
----------
abc
abc
fcd

(3 ÐÐÊÜÓ°Ïì)

*/

---

SQL code

---

Code highlighting produced by Actipro C