Buy Questpond's video subscriptions on
huge discount
.
Online: 1309
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Codes
>
Loading ...
Display preceisely 2 digits after decimal point in SQL Server
Posted by
Rajnilari2015
under
Sql Server
category on
4/20/2016
|
Points: 40
| Views : 747
Post Code
|
Search Codes
|
Code Home
Suppose we have a number like 123456.98072340
The output should look like 123456.98 i.e. precisely 2 digits after decimal.
The query is:
SELECT CAST(ROUND(123456.98072340, 2, 1) AS DECIMAL(18, 2))
Alert Moderator
Bookmark It
Comments or Responses
Login to post response
Latest Code Snipptes
Ecommerce Web Development Company
Custom Software Development Solution
Live Streaming App Development
React Native Development Solution
Video Streaming App Development
Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
More ...