Arthur Fuller responds to a reader who sent him a question recently asking how to display currency amounts in currency format. Check out the solution he offers for the reader's problem.

In the data format configuration, I set my locale to "Belgium" so all numbers are formatted with a comma as decimal separator (instead of period). This works fine for all columns with datatype decimal ...

Thanks for the info all.<BR><BR>For my current need, a trimmed format did the trick but I'll keep in mind datepart and datename.

Simplifying deployment and cost management by using modern pay-as-you-go subscription for SQL Server software. Learn more.

Bug Report BC Break: no Version: DBAL 2.8 Summary When using SQL Server 2008 or above, updating a DATETIME column in the database fails on commit. Current behaviour When performing an UPDATE with a ...

By deploying Microsoft SQL Server 2000 Windows CE Edition, leading companies such as Nabisco Inc., Creeden &Associates and Rubicon Technologies have optimized business processes.

When working with dates and times in SQL Server, it’s common for formatting discrepancies to cause issues during query execution. To prevent errors, it’s crucial to ensure that date strings are ...

Microsoft SQL Server has become a business-critical database for a growing number of enterprises that rely on it to run a wide range of essential business processes. As enterprises look to ...