9 Things to Do When You Inherit a Database
Some tips on what to do when you inherit a database that you've never worked on before
2012-06-26 (first published: 2009-06-22)
55,492 reads
Sylvia Moestl Vasilik
Easy Error Trapping When Using xp_cmdshell
Getting errors and output messages when using xp_cmdshell can be tricky. This method can solve your problems.
2010-02-02
11,657 reads
Enhancing the readability of your code: Table aliasing in sql
When writing SQL, picking good tables aliases can greatly enhance the readability of your code
2009-05-07
7,984 reads
Blogs
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Killing Explicit Sort Steps in Redshift with the Right SORTKEY
You paste a slow Redshift query plan into PlanTrace and one of the tuning...
AI Experiments: Parsing Payment Memos
By Steve Jones
As part of my running the SQL Saturday charitable foundation, I get sponsorship money...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
Question of the Day
Displaying Money
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 EurosSee possible answers