Using DTEXECUI to generate a DTEXEC command line statement the easy way
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool...
2013-08-05 (first published: 2013-07-31)
2,718 reads
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool...
2013-08-05 (first published: 2013-07-31)
2,718 reads
Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle...
2013-07-31 (first published: 2013-07-22)
3,625 reads
I’ve had to debug database mail problems several times over the last year or so. Below is a collection of...
2013-07-29
1,403 reads
I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused...
2013-07-24
664 reads
I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting.
First here...
2013-07-22 (first published: 2013-07-15)
2,555 reads
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead...
2013-07-17
838 reads
Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is...
2013-07-15 (first published: 2013-07-08)
2,195 reads
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions...
2013-07-01
2,737 reads
How will you back out if your change doesn’t work?! Always take a backup! There should always be a back...
2013-06-26
2,426 reads
What is a metadata function? According to BOL a metadata function is one that returns data about the database or...
2013-06-24
842 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
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