Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
How to round a Column defined as Float on INSERT and UPDATE in SQL Server 2005
code_junkie
Nov 14th, 2011
120
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
text
0.09 KB
| None
|
0
0
raw
download
clone
embed
print
report
update tbl set column = round(column * 100) / 100
CONVERT(money, your_float_column)
Add Comment
Please,
Sign In
to add comment
Public Pastes
🤑G2A.com Free Gift Card Guide June 2024 Fix🎁
JavaScript | 5 min ago | 0.32 KB
🤑G2A.com Free Gift Card Guide June 2024 Fix🎁
JavaScript | 11 min ago | 0.34 KB
🤑G2A.com Free Gift Card Guide June 2024 Fix🎁
JavaScript | 17 min ago | 0.33 KB
🤑G2A.com Free Gift Card Guide June 2024 Fix🎁
JavaScript | 23 min ago | 0.33 KB
🤑G2A.com Free Gift Card Guide June 2024 Fix🎁
JavaScript | 30 min ago | 0.33 KB
🤑G2A.com Free Gift Card Guide June 2024 Fix🎁
JavaScript | 36 min ago | 0.32 KB
RiverStencilCopy
C# | 39 min ago | 1.42 KB
🤑G2A.com Free Gift Card Guide June 2024 Fix🎁
JavaScript | 42 min ago | 0.33 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!