T-SQL Tuesday/Wednesday #21: A Crappy Workaround
A long time ago (in IT terms) in a galaxy far, far away I was helping an organization with a...
2011-08-10
2,066 reads
A long time ago (in IT terms) in a galaxy far, far away I was helping an organization with a...
2011-08-10
2,066 reads
There are a few posts and articles around the security-scape lately concluding Windows 7 is more secure than OS X,...
2011-08-09
818 reads
My primary responsibility at my organization is no longer to be the security architect and incident response team lead. I...
2011-08-08
959 reads
I'm always wary of contests to win free stuff, but the folks running MSSQLTips.com are legitimate (I write there as...
2011-08-04
1,043 reads
I grew up immersed in security. My father was a US Marine and going on and off base meant... security....
2011-08-03
1,233 reads
We recently ran into a case where connecting to a Windows Server 2003 server with SQL Server installed on it,...
2011-08-02
15,674 reads
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-28
2,180 reads
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-25
1,061 reads
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-22
1,374 reads
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-21
731 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...
CSO BCA 0817839777 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur...
CSO, BCA. 0817839777 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates,...
CSO BCA : 0817839777 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
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