by andrew novick | Dec 15, 2020 | SQL coding
I responded to a posted question about the EOMONTH() function, which was: if there’s an EOMONTH function, why isn’t there a start of month function. The reason is that DATEFROMPARTS does the trick. It was added in SQL 2012 along with EOMONTH and...
by Ian Bachman-Sanders | Dec 10, 2020 | SQL coding
This article continues where the last one left off. If you’d like and go back and read that one you can find it here. In that article, an updatable view was created to replace an existing table. The table had been named myData and was renamed myDataBaseTable....
by andrew novick | Dec 9, 2020 | SQL coding, SQL Performance
I attended a webinar on Microsoft Databricks yesterday. The only link I have is a zoom registration so you’ll have to search. I’m sure they’ll run it again. The hands-on-lab made it very worthwhile. The rest was marketing fluff. They did a good...
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...
