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,223 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Brute-force searching for data.
Today, I needed a way of searching through a database, any database, looking for a certain string. The procedure I...
2011-07-08
3,811 reads
Belt and braces
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,588 reads
'Topping and Tailing' strings in database tables
/*
When you are having to extract just part of a string in TSQL, there are a number of techniques you...
2011-06-14
2,222 reads
A Quick TRIM, Sir?
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,153 reads
Silly Billiseconds
You have to admire Microsoft for sticking to their guns, even when being palpably stupid. I refer, of course to...
2011-01-13
3,341 reads
Listing members of a group in SQL Server.
In SQL we are used to the GROUP BY and the type of result it produces. In real life, we...
2010-10-11
1,559 reads
Cleaning up excess contiguous spaces in strings. A mystery.
/* Have you ever come across the problem where you have to remove spaces from a string that has too many?...
2010-09-30
2,978 reads
COMPUTE: now it is going, what else will do it?
/*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,618 reads
Ambiguities and the wild object.oriented brigades
--Whilst trying to design a more effective way of detecting dependencies in a SQL Server database, I was mulling over...
2010-07-29
2,010 reads
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers