update 你的表
set 字段C=
ltrim(right(ltrim(right(字段A,len(字段A) - charindex(' ',字段A))),len(ltrim(right(字段A,len(字段A) - charindex(' ',字段A)))) - charindex(' ',ltrim(right(字段A,len(字段A) - charindex(' ',字段A)))))),
字段B = rtrim(left(ltrim(right(字段A,len(字段A) - charindex(' ',字段A))),charindex(' ',ltrim(right(字段A,len(字段A) - charindex(' ',字段A))))))
set 字段C=
ltrim(right(ltrim(right(字段A,len(字段A) - charindex(' ',字段A))),len(ltrim(right(字段A,len(字段A) - charindex(' ',字段A)))) - charindex(' ',ltrim(right(字段A,len(字段A) - charindex(' ',字段A)))))),
字段B = rtrim(left(ltrim(right(字段A,len(字段A) - charindex(' ',字段A))),charindex(' ',ltrim(right(字段A,len(字段A) - charindex(' ',字段A))))))
set 字段C=
ltrim(right(ltrim(right(字段A,len(字段A) - charindex(' ',字段A))),len(ltrim(right(字段A,len(字段A) - charindex(' ',字段A)))) - charindex(' ',ltrim(right(字段A,len(字段A) - charindex(' ',字段A)))))),
字段B = rtrim(left(ltrim(right(字段A,len(字段A) - charindex(' ',字段A))),charindex(' ',ltrim(right(字段A,len(字段A) - charindex(' ',字段A)))))),
字段A = rtrim(left(字段A,charindex(' ',字段A)))
create table tablet(
A nvarchar(100),
B nvarchar(100),
C nvarchar(100)
)insert into tablet(A) values('AAA BBB CCC')
insert into tablet(A) values('DDD EEE XSS')
insert into tablet(A) values('VVV SSS WWW')
exec master..xp_cmdshell 'bcp "select A from ColinTest..tablet" queryout c:\ddd.txt -c -Scx -Uwang -P000711'delete from tabletBULK INSERT ColinTest..tablet FROM 'c:\ddd.txt'
WITH (
DATAFILETYPE = 'char',
FIELDTERMINATOR = ' ',
ROWTERMINATOR = '\n'
)select * from tablet