If you wish to Format Number to 2 decimal without rounding it then, here is the trick.This is also useful when you are dividing 2 numbers and you need answer in 2 digiits only without rounding
2005-07-25 (first published: 2005-06-23)
499 reads
It is quite often that we need to find Nth (5th or 8th or 10th) maximum or minimum number of record from the record set. The solution is different in MS SQL than in Oracle because we have RowNum in Oracle. Some time ago I got the same problem with a massive table of more […]
2005-07-22 (first published: 2005-07-05)
1,055 reads
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
By Chris Yates
I get asked a lot about why or how I began working with databases...
Comments posted to this topic are about the item Getting the Object Code
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Being Mindful of Design Time
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers