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
21,040 reads
Here are a couple of functions to convert between roman numerals and integers. They are handy for all sorts of...
2011-09-20
21,040 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,787 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,582 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,212 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,144 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,318 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,550 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,967 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,994 reads
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...
By Steve Jones
I can’t believe I’ve been at Redgate long enough to get a third sabbatical....
Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...
Comments posted to this topic are about the item Can You Ask for a...
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers