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,446 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,446 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,701 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,579 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,202 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,133 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,294 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,525 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,952 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,608 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,983 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers