I used to create my application database by managing a series of install scripts with one table or stored procedure per file. In those files I had to manage potential changes to those schema items and also handle conditional creation of those entities if they
Recently someone asked how to break apart multiple values stored together in a single field. I’ve written a number of variations of functions that perform this task in SQL Server. Purpose Some of you may ask why would you ever do such a thing. You