Startup

This is a script that I run when SQL starts to notify me via email that a server has restarted as well as the location of the server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(7)

You rated this post out of 5. Change rating

2012-09-25 (first published: 2012-08-29)

1,880 reads

Blogs

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

Reading tutorials is fine. Shipping something is better. If you are trying to break...

We work hard at Redgate, though with a good work-life balance. One interesting observation...

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