T-SQL Context Switching
Being a standards advocate, Steve has a few thoughts on team code structure.
2019-10-07
421 reads
Being a standards advocate, Steve has a few thoughts on team code structure.
2019-10-07
421 reads
The idea of using more unit tests to improve code quality has been around for some time. However Steve Jones notes today that some people use tests for documentation.
2019-10-04 (first published: 2015-05-14)
279 reads
2019-10-04
673 reads
I’m off to Memphis today for SQL Saturday #870. I’m excited as I’ve never been to Memphis and hope to wander around and see something while I’m there. I...
2019-10-04
44 reads
This is part of a demo series I did for a customer workshop. I’m adding a little more detail and explanation of the demos of products I gave. A...
2019-10-04 (first published: 2019-09-30)
404 reads
If you have a list of striped backup files, how can you find the latest backup set? Steve Jones uses dbatools and PowerShell to automate this process.
2019-10-03
2,620 reads
2019-10-03
235 reads
2019-10-03
1,222 reads
2019-10-02
448 reads
Learning how an organization, or even just a codebase, works can be a challenge for new employees.
2019-10-02
146 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