Roman Numerals to integers, and Vice Versa, in SQL:
Here are a couple of functions to convert between roman numerals and integers. They are handy for all sorts of...
2011-09-20
20,917 reads
Here are a couple of functions to convert between roman numerals and integers. They are handy for all sorts of...
2011-09-20
20,917 reads
Today, I needed a way of searching through a database, any database, looking for a certain string. The procedure I...
2011-07-08
3,776 reads
A moment ago, I was deep in some coding. What it was is not entirely relevant, With a page-full of...
2011-06-30
2,581 reads
/*
When you are having to extract just part of a string in TSQL, there are a number of techniques you...
2011-06-14
2,209 reads
The other day, I was answering a question on the ASK.SQLSERVERCENTRAL.COM forum from a programmer who had hit a
problem...
2011-01-28
2,141 reads
You have to admire Microsoft for sticking to their guns, even when being palpably stupid. I refer, of course to...
2011-01-13
3,314 reads
In SQL we are used to the GROUP BY and the type of result it produces. In real life, we...
2010-10-11
1,547 reads
/* Have you ever come across the problem where you have to remove spaces from a string that has too many?...
2010-09-30
2,964 reads
/*I'd be very surprised if you've ever used the old COMPUTE clause in SQL Server. It is a bit mad,...
2010-09-23
1,614 reads
--Whilst trying to design a more effective way of detecting dependencies in a SQL Server database, I was mulling over...
2010-07-29
1,993 reads
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
By Rayis Imayev
(2025-Feb-12) I will jump straight to the problem statement without a "boring" introduction, which, in...
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI I’m...
I’m encountering an SSL certificate chain issue when trying to connect to my SQL...
Comments posted to this topic are about the item How Much Linux Do You...
What is the precision, scale, and length for an int variable?
See possible answers