22,181
社区成员




declare @sql varchar(1000)
select @sql='select ltrim((select '+replace(replace('1/3,1/4,1/5','/','.0/'),',','))+'',''+ltrim((select ')+'))'
exec(@sql)
/**
------------------------------------
0.333333,0.250000,0.200000
**/
declare @sql varchar(1000)
select @sql='select '+replace(replace('1/3,1/4,1/5','/','.0/'),',',' union all select ')
exec(@sql)
/**
---------
.333333
.250000
.200000
**/
create table tb(col varchar(10))
insert into tb values('1/3')
insert into tb values('1/4')
insert into tb values('1/5')
go
select left(col , charindex('/' , col) - 1) * 1.0 /
substring(col,charindex('/' , col) + 1 , len(col))
from tb
where charindex('/' , col) > 1
/*
---------------
.33333333
.25000000
.20000000
(所影响的行数为 3 行)
*/
drop table tb
create table tb(col varchar(10))
insert into tb values('1/3')
insert into tb values('1/4')
insert into tb values('1/5')
go
select left(col,charindex('/',col)-1)*1.0/right(col,len(col)-charindex('/',col)) from tb
/*
---------------------------------------
0.33333333
0.25000000
0.20000000
(3 行受影响)
*/
drop table tb
select left(col,charindex('/',col)-1)*1.0/right(col,len(col)-charindex('/',col))