sql 字段内容转换显示语句

[icemanpro]

现有一字段A，其内容为123-412-asd,123-33-31
现想在select 时，将其内容转换成
'123-412-asd','123-33-31'

有什么语句可以达到？

[dawugui]

分成两段?

select left(a , charindex(',',a) - 1),
substring(a , charindex(',',a) + 1 ,len(a))
from tb

[快乐_石头]

declare @s varchar(50)
set @s='123-412-asd,123-33-31 '
select ''''+replace(@s,',',''',''')+''''
/*
'123-412-asd','123-33-31 '

(1 個資料列受到影響)

*/

[dawugui]

create table tb(A varchar(50))
insert into tb values('123-412-asd,123-33-31') 
go

select c1 = left(a , charindex(',',a) - 1), 
       c2 = substring(a , charindex(',',a) + 1 ,len(a)) 
from tb 
where  charindex(',',a) > 0


drop table tb

/*
c1                                                 c2                                                 
-------------------------------------------------- -------------------------------------------------- 
123-412-asd                                        123-33-31

（所影响的行数为 1 行）


*/

[xiequan2]

declare @s varchar(1000)
set @s='123-412-asd,123-33-31'


select replace(''''+@s+'''',',',''',''')

/*
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
'123-412-asd','123-33-31'
*/

[ws_hgo]

declare @str nvarchar(100)
set @str='123-412-asd,123-33-31'
select substring(@str,0,charindex(',',@str))+','+substring(@str,charindex(',',@str)+1,len(@str)-charindex(',',@str))

[SQL77]

DECLARE @S NVARCHAR(400)
SET @S='123-412-asd,123-33-31'
SELECT REPLACE(''''+@S+'''',',',''',''')
                                                                                                                                                                                                                                                                 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
'123-412-asd','123-33-31'

（所影响的行数为 1 行）

[ws_hgo]

一句话
太快啦

[yananguo_1985]

select left([Col],charindex(',',[Col])-1),substring([Col],charindex(',',[Col])+1,len([Col])) from [table]

[SQL77]

DECLARE @S NVARCHAR(50)
SET @S='123-412-asd,123-33-31'
SELECT PARSENAME(REPLACE(@S,',','.'),1),
PARSENAME(REPLACE(@S,',','.'),2)


                                                                                                                                                                                                                                                                  
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- 
123-33-31                                                                                                                        123-412-asd

（所影响的行数为 1 行）