Rob Farley did a nice writeup on how to create
A Fix() Function in T-SQL, using TDD concepts to boot.
Final code:
create function dbo.fix(@num float, @digits int) returns float as
begin
declare @res float
select @res = case
when @num > 0
then round(@num,@digits-1-floor(log10(@num)))
else round(@num,@digits-1-floor(log10(-@num)))
end
return (@res)
end
Technorati Tags: sql, programming, tdd
posted by Oskar Austegard at 10:09 AM on Jul 25, 2006
"A Fix() Function in T-SQL"
No comments yet. -