by Ian Bachman-Sanders | Dec 2, 2020 | SQL coding
A reader, Rebecca, wrote asking: I have a table that contains a column. That table and column are used throughout our web site. The column is no longer valid and needs to come from another table. I need to quickly do this without having to change all of the code in...
by Ian Bachman-Sanders | Nov 23, 2020 | SQL coding
There are many reasons for almost every table to have a primary key. This articles UDF locates any user tables that don’t have primary keys. Here’s the CREATE FUNCTION script: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE FUNCTION...
by Ian Bachman-Sanders | Nov 22, 2020 | SQL coding
A while ago I did a presentation about software distribution for Smart Client applications using .Net technologies. Part of the discussion was about the history of software distribution. Fifteen years ago problems were often dominated by DLL Hell and the Windows...
by Ian Bachman-Sanders | Nov 18, 2020 | SQL coding
Credit card numbers are among the most common numbers in commercial use today. Most credit card numbers and many other numbers used in financial services use the Luhn (a.k.a Mod 10) formula for check digits. It’s been formalized as part of the ANSI X4.13...
by Ian Bachman-Sanders | Nov 17, 2020 | SQL coding
The number of ways to receive information seems to increase all the time. One of the ways to get information from the web is an RSS feed. If you use a feed reader. This issue features a contribution from reader Nick Barclay from Australia. The function, InString, is...