SQL

Here you will find useful articles, downloadable tools, links, etc about databases, SQL and Microsoft SQL Server in particular.

am_nextDayOfDate - user defined function (UDF)
Returns the closest day of the week after a specified date. For example, you could get the next Wednesday after a certain date.

Converting comma-delimited or fixed-width strings of any length into a table that you can use in a subquery, join with, etc.

Simple Log Shipping - improved version of Microsoft-written stored procedures that implements a pretty robust and fairly easy to use system of shipping logs to a standby instance

 

© Copyright 1996-2010 by am.net and Solitex Networks. Legal Notices.
Creative Commons License Articles on this site are licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.