문자열을 카멜 표기법으로 치환

'_' 다음 문자를 대문자로 치환한다.

create function dbo.columnNameChange

(

@txt varchar(255)

)

returns varchar(255)

as

begin

declare

@makeString varchar(255)

, @start int

, @checkString varchar(1)

, @LChar varchar(1)

set @makeString = ''

set @start = 0

set @checkString = ''

set @LChar = ''

set @txt = lower(@txt)

while @start <= len(@txt)

begin

set @checkString = substring(@txt, @start, 1)

if @checkString = '_'

begin

set @LChar = 'Y'

end

else

begin

if @LChar = 'Y'

begin

set @LChar = ''

set @checkString = upper(@checkString)

end

set @makeString = @makeString + @checkString

end

set @start = @start + 1

end

return @makeString

end

go