SQL英文字符与中文换位

显示全部楼层 · 2013-10-8 15:09:38

给你写出通用方式吧，，，，用函数来实现，，，create function test_uf(@s nvarchar(200)) returns nvarchar(200) as begindeclare @i int, @a nvarchar(1), @s1 nvarchar(200),@s2 NVARCHAR(200) set @i = 1 set @s1 = ''set @s2 = '' while @i = 'a' and @a = 'A' and @a = '...

千问 · 2013-10-8 15:09:38

SELECT col1,
TRANSLATE
('联接按钮WMP400',
'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890'
|| col1,
'ABCDEFGHI...

千问 · 2013-10-8 15:09:38

update 表 set 品名=(casewhen charindex('WMP', 品名)>1 then left(品名,charindex('WMP',品名)-1)+right(品名,len(品名)-charindex('WMP',品名)+1)when charindex('HM', 品名)>1 then left(品名,charindex('HM',品...