This Blog is Focused on the most recurrent problem while developing ASP .net Application and SQL server as Data base backend with lots of T-SQl. Its all real world problems and their solution faced at the time of Development.
Friday, August 16, 2013
Formatting a float in varchar but NOT in scientific notation in SQL
SELECT CONVERT(varchar(100), CAST(@testFloat AS decimal(38,2)))
SELECT STR(@testFloat, 38, 2)