Posted By awais9981 on 10 Jan 2013 05:44 PM
Check the following link http://msdn.microsoft.com/en-US/lib...80%29.aspx
it says that
Fixed-point notation is used if the exponent that would result from expressing the number in scientific notation is greater than -5 and less than the precision specifier; otherwise, scientific notation is used. The result contains a decimal point if required and trailing zeroes are omitted. If the precision specifier is present and the number of significant digits in the result exceeds the specified precision, then the excess trailing digits are removed by rounding.
The exception to the preceding rule is if the number is a Decimal and the precision specifier is omitted. In that case, fixed-point notation is always used and trailing zeroes are preserved.
If scientific notation is used, the exponent in the result is prefixed with 'E' if the format specifier is 'G', or 'e' if the format specifier is 'g'.
when you use 0.000075( 7.5e-05) then exponent is -5 so in this case scientific notation is being used.
while when you use 0.00075( 7.5e-04) then exponent is -4 which is greater than -5. so in this case fixed-point notation is being used.
it seems to me that default string formats for float in SQL Server and .NET are same.:)
Muhammad Awais Akram