KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a view in SQL server, something like this: select 6.71/3.41 as NewNumber The result is 1.967741 (note 6 decimal points) -> decimal (38,6) I try the same thing in a calculator but the result is 1.967741935483871xxxx I want to force SQL Server to return more accurate result something like decimal(38,16) I have tried the obvious things like casting, but SQL Server doesn't improve the output I just get some trailing zeros at the end like 1.9677410000 Is there a way to force SQL Server to not truncate the result or give more accurate one?
Tags (comma-separated)
Save Edits
Cancel