--> 生成测试数据表:tbIF 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 行受影响)*/
IF OBJECT_ID('TB') IS NOT NULL DROP TABLE TB GO CREATE TABLE TB(A VARCHAR(20)) INSERT INTO TB SELECT 'a b c' UNION ALL SELECT 'ab c' UNION ALL SELECT 'f c d' --查询 SELECT A,REPLACE(A,' ','') FROM TB /* a b c abc ab c abc f c d fcd */ --修改 UPDATE TB SET A=REPLACE(A,' ','')SELECT * FROM TB /* abc abc fcd */
A,REPLACE(A,' ','')
FROM TB
update tb
set A=replace(A,' ','')??
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 行受影响)*/
GO
CREATE TABLE TB(A VARCHAR(20))
INSERT INTO TB
SELECT 'a b c' UNION ALL
SELECT 'ab c' UNION ALL
SELECT 'f c d'
--查询
SELECT A,REPLACE(A,' ','') FROM TB
/*
a b c abc
ab c abc
f c d fcd
*/
--修改
UPDATE TB SET A=REPLACE(A,' ','')SELECT * FROM TB
/*
abc
abc
fcd
*/
replace