Technical Article

Remove decimal places without rounding

There was a script here not too long ago which showed how to 'truncate' a number to two decimal places without rounding. This used a lot of casts to varchars and back.The solution worked, but I knew there had to be a way of doing exactly this without having to go back and forth between […]

2005-08-08 (first published: )

1,285 reads

Blogs

Daily Coping 28 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

Read the latest Blogs

Forums

Azure Pricing, SQL Server seems pretty high?

By keven11

Hi, I'm really new to this and I think I've got this wrong, wondering...

Linked Server only tables in catalog are available

By daniel.dolan

I have two servers, ServA and ServB. ServA is set up as a linked...

NOT and NULL

By kuopaz

I've been here before on this but have come across it again, so wanted...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers