This is a comment on/modification of the Usp_FindAllDBSizes script on Sept 17th.Why use an inner loop when you can use a select stmt?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-09-17

114 reads

Blogs

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...

Forums

WhatsApp CS,0817844112 Jl. Pangeran Diponegoro No.15, Petisah Tengah, Kec. Medan Petisah, Kota Medan, Sumatera...

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

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

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

SELECT @YenAmount AS RawValue;