SQL is a widely-used programming language for computer databases in business. Frequently, software developers need to combine different kinds of data, such as integer and character fields, into a ...

One of the presentations I enjoyed at Rocky Mountain Oracle Users Group (RMOUG) Training Days 2010 was Stephen Jackson’s presentation “Using SQL to Generate SQL.” I have used some of the techniques he ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Ok, I'm at a client site where they want to make a program database independent. This is a rewrite of an existing program that used an Access database only. I asked the person in charge how they were ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...