Typo in explanation "collaction" instead of "collation".

I think the "internal" version of the query in the article. was wrong. It was:

SELECT * FROM dbo.Person

WHERE User_Name() = 'User_CS'

That would return all rows if executed by...

I use SSMS for ad-hoc querying and testing various solutions.

But, I maintain databases using SSDT projects. For source control, deployment, comparison, finding references, it's great.

I don't think you need the TOP 1 in the existence tests. EXISTS (SELECT...) already has the optimization of stopping after the first row built in.

If two decimal places are ok, you can just convert the string to money, then back to a string with a style of 1.

SELECT CONVERT(varchar(24),CONVERT(money,'12345678'),1)

returns: 12,345,678.00

If it's important to...