thomasrushton

SQL Server DBA - part-time since 1995, full-time since 2010.

Technical Article

Function to express numeric value in words

There is a requirement here to take a number (such as 124995) and express it in words.  We needed a function to do this, as it would be used in an existing document generation system.I have developed the enclosed two functions to do this.  Note that the function does not, currently, cater for negative numbers, […]

You rated this post out of 5. Change rating

2002-12-06

122 reads

Blogs

Opening the SQL Prompt Command Palette

By

A few years ago SQL Prompt added a command palette to let you search...

Common Mistakes in SQL Server – Part 2

By

The  Identity property creates an incremental value for the specified column automatically, which is...

Enable PowerShell Remoting

By

Enable PowerShell Remoting I use PowerShell quite a lot...

Read the latest Blogs

Forums

Restore With Standby; A Review and A Lesson Learned

By Andy Warren

Comments posted to this topic are about the item Restore With Standby; A Review...

Are You Worried About AI?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are You Worried About AI?

The Upgraded Procedure part 2

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Upgraded Procedure part 2

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers