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 ...
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 ...