We recently had the need for a string split function on our SQL Server 2014 database server, but found that there is not a built in function for that version of SQL Server.  So we researched it a little and found a function definiton that mostly suited our requirements.  We took the liberty of making changes that meet our requirements.  (We wanted a StringSplit function that works in a similar fashion to the C# string.Split function.  We modified the function downloaded from internet website contained in the comments of our script definition to also return empty strings in the 'array' (really a table, but SQL Server 2014 does not support indexable array as best as we can tell).)

While testing our version of the StringSplit function we found a need for a StringFormat function that makes use of StringSplit.  Anyway long story short, we implemented a StringFormat function.

Use the following links to download the function create scripts and feel free to make any modifications you see fit for your purposes.

Note: the QueryToCreateStringFormat_3Function.sql file is one of ten versions of function wrappers to allow for different numbers of parameters from your calling script.  The pattern is that the underscore number value indicates how many parameters to pass into this function _3 indicates that three parameters other than the FormatSpecifierString are passed into the function.  It is fairly easy to create the other nine versions of the function starting with this function.

Thanks for reading our post and we hope these functions can be of use to you!

QueryToCreateSplitStringsFunction.sql

QueryToCreateStringFormatFunction.sql

QueryToCreateStringFormat_3Function.sql

We've been working on updates to the sBlog.Net engine.  Changes are being made to the v3.0 git hub version that was downloaded and built/ deployed to our server.  We have added a new setting to the database backend that controls the number of years included in the archives panel of the sidebar.  The archives panel was also updated to display the month/year combinations in three columns instead of one so that this panel takes up less vertical screen space. We also have added a web.config setting to allow for emails to be sent to admin under certain conditions such as exception logging and user requests for login accounts.  The email handler was updated to work with our admin's smtp mail server.  A few changes to the styles to make the Bootswatch Slate theme consistent for authors page and comments.  A few patches to handle paging a little bit better when a user is on a blog page other than page one and they click the link for blog authors and the blog pages paging logic was inverted to make the next page increment to next higher page number and previous page to decrement to the next lower page number.

We also added a site icon which was setup with our logo.  Once our changes that are not specific to Horvath Software Solutions instance of sBlog.Net have been proven to work correctly and are in keeping with the design of orginal developer of sBlog.Net, we may publish our changes to the git hub repository.

Thanks for reading our post!

...

...

This post is a first for me with an image file embedded in the post.

The following is a photo taken at Lake DeGray in Arkansas:

This blog site contains news about what I've been working on at Horvath Software Solutions (HSS).  This little company is here to provide software development at rates larger companies cannot provide.  We hope you like what you see on this blog site and our main site, https://horvathsoftware.com.  The main site demonstrates some of our capabilities being that it is an ASP.Net MVC web application and we have provided sample desktop applications for download from that site.  If you have an idea for an application but don't have the skils or time to build it yourself, contact me and it would be my pleasure to work with you to make your idea a reality.  Thank you for reading my post and look for more in the future!