Mike DiRenzo

Querying the INFORMATION_SCHEMA

Using a macro to query the INFORMATION_SCHEMA

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(20)

You rated this post out of 5. Change rating

2008-03-03

16,080 reads

Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...

You paste a slow Redshift query plan into PlanTrace and one of the tuning...

As part of my running the SQL Saturday charitable foundation, I get sponsorship money...

Comments posted to this topic are about the item Displaying Money

Comments posted to this topic are about the item The Slow Growing Problems

Comments posted to this topic are about the item Calculating the Harmonic Mean in...

I want to get the currency sign displayed with my amount stored in a money type. Does this work?

DECLARE @Amount MONEY;
SET @Amount = '?1500';

SELECT CAST( @Amount  AS VARCHAR(30)) AS Euros