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
18,878 reads
Here are a couple of functions to convert between roman numerals and integers. They are handy for all sorts of...
2011-09-20
18,878 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,482 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,578 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,188 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,108 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,264 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,509 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,934 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,606 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,980 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Over the past couple of years, I’ve developed several tools that I’ve been using...
/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...
If i deploy a standalone Azure VM running SQL Server into an availavility zone;...
So I have inherited an older SQL 2014 Server and have been working on...
Hi, I need to update my sql script and remove the UNION but get...