问一特基础的SQL语句

Question

select
 hm=case when charindex('//',hm)>0 then left(hm,charindex('//',hm)-1) else hm end,
 dz=case when charindex('//',hm)>0 then stuff(hm,1,charindex('//',hm)+1,'') else '' end
from t

Answer 1

select 
stuff('张三//××市××区××号',charindex('//','张三//××市××区××号'),len('张三//××市××区××号'),''),
stuff('张三//××市××区××号',1,charindex('//','张三//××市××区××号')+1,'')

Answer 2

select 
    hm = left(hm,charindex('//',hm)-2),
    dz = stuff(hm,1,charindex('//',hm),'')
from
    表

Answer 3

select 
stuff(hm,charindex('//',hm),len(hm),''),
stuff(hm,1,charindex('//',hm)+1,'')
from tb

Answer 4

select left(hm,patindex('//',hm)) as hm,right(hm,len(hm)-patindex('//',hm)) 
as dz from 表

Answer 5

--增加dz列
alter table tname add dz varchar(100)--更新数据
update tname
set 
    dz = stuff(hm,1,charindex('//',hm),''),
    hm = left(hm,charindex('//',hm)-2)

Answer 6

select hm=left(hm,charindex('//',hm+'//')-1),
       dz=stuff(hm,1,charindex('//',hm+'//'),'')
from tb

Answer 7

select left(hm,patindex('%//%',hm) -1)as hm,right(hm,len(hm)-patindex('%//%',hm)) as dz from 表

Answer 8

Select Left(hm,CharIndex('/',hm)-1) As hm,
Right(hm,Len(hm)-CharIndex('/',hm)-1) As dz
from 表

Answer 9

select left(hm,patindex('%//%',hm) -1)as hm,right(hm,len(hm)-patindex('%//%',hm)-1) as dz from 表