SQLStudies

My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...

2012-09-02

4,115 reads

At Startup SSMS setting

I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I...

2012-08-27

662 reads

In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...

2012-08-20

1,343 reads

We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...

Hallo all! My problem is this: I have quite a bunch of TSQL scripts...

Comments posted to this topic are about the item Converting Money

hi, we couldnt get our upstream data source developers to supply what is sometimes...

Does this run successfully on a SQL Server 2022, US English default installation?

DECLARE @YenAmount MONEY;
SET @YenAmount = ¥1500; 

SELECT @YenAmount AS RawValue;