T-SQL: Disable default FLOAT rounding when using Table with its View?

You can have it store more digits, but it's going to switch to scientific notation.

You can have it store more digits, but it's going to switch to scientific notation: CREATE TRIGGER dbo. Tr_TestTableFloatInsert ON dbo. TestTableFloat INSTEAD OF INSERT AS BEGIN SET NOCOUNT ON; insert into TestTableFloat_E (FloatField) select CONVERT(varchar(100),FloatField,2) FROM INSERTED END Which ends up storing 1.231234560000000e+002 into the table.

From CAST and CONVERT: When expression is float or real, style can be one of the values shown in the following table. Other values are processed as 0. 0 (default) A maximum of 6 digits.

Use in scientific notation, when appropriate. 1 Always 8 digits. Always use in scientific notation.2 Always 16 digits.

Always use in scientific notation. Insert usual caveats about futility of expecting float and a decimal representation of the same to always be exactly convertible, and of using inappropriate data types to store particular types of data It would appear the best data type to use for this data would be decimal with appropriate scale and precision, which is neither of the types you're working with. But you claim that those are the "required" types.

E.g. If the view uses a decimal instead of a float, the stored varchar(100) value is exactly as expected.

Incredible... I thought nobody understand, what I wrote and want here. Select CONVERT(varchar(100),FloatField,2) what I need. Thanks!

– Chaki_Black Sep 28 '11 at 15:01.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.