This area of the site is dedicated to code snippets for quick and easy reference
CAUTION: This is a very powerful script, use at your own risk! This script will: Drop all non-system stored procs Drop all views Drop all functions Drop all Foreign Key constraints Drop all Primary Key constraints Drop all tables
This application should not be used as a replacement for Microsoft’s W32Tm NTP Sync functionality. This application however will help when you do not have that service working. InternetTime Namespace (majority of the code) credit goes to Valer Bocan viewable at http://dotnet-snippets.com/snippet/simple-network-time-ntp-protocol-client/571 NTP Namespace is my addition to Valer’s code, while not industry standard in…
GitHub: https://gist.github.com/dkittell/c3c930d1b432d51ebb71
For more connection string assistance visit: http://www.connectionstrings.com/
Recently I was asked to help convert Gregorian Date to Hijri Date and vice versa. One thing to note is that with Hijri date format you must keep it as a string.
This code will assist in helping you create a column should it not already exist.
Sometimes a zip code is presented in a database with all nine numbers in the same column that has only five numbers. This query below will assist in formatting the numbers properly. Source: http://forums.sqlmag.com/forums/aft/77318
You must be logged in to post a comment.