Add Column If Does Not Exist

Posted on By David Kittell

This code will assist in helping you create a column should it not already exist.

IF COLUMNPROPERTY(OBJECT_ID('dbo.address'), 'zip4', 'ColumnId') IS NULL
BEGIN
	ALTER TABLE address
	ADD zip4 INT NULL
END
Originally Posted on November 12, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL SQL

Related Posts

SMTP Mail

Posted on

MailMessage m = new MailMessage(); SmtpClient sc = new SmtpClient(); m.From = new MailAddress("email@email.com", "Name Of Person"); m.To.Add(new MailAddress("email@email.com", "Name Of Person")); m.CC.Add(new MailAddress("email@email.com", "Name Of Person")); m.Subject = "Email Subject"; m.Body = sResultsHTML; AlternateView av = AlternateView.CreateAlternateViewFromString(sResultsHTML, null, MediaTypeNames.Text.Html); m.AlternateViews.Add(av); sc.Port = 25; sc.Host = "mail.email.com"; // Email server…

Read More

File Upload Web Service

Posted on

This is a File Upload Web Service that can be a wrapper for a process in between. Source code is an adaptation of this Microsoft article: HOW TO: Send and Receive Binary Documents by Using an ASP.NET Web Service and Visual C# .NET Upload Client using System; using System.Collections.Generic; using…

Read More

VB.NET – Remove Empty Folders

Posted on

‘Remove Empty Folders – Start Public Shared Sub RemoveEmptyFolders(ByVal path As String) Dim directory As New DirectoryInfo(path) For Each subDirectory As DirectoryInfo In directory.GetDirectories() If subDirectory.GetFiles().Length = 0 Then Try subDirectory.Delete() Catch ex As Exception End Try End If Next subDirectory End Sub ‘Remove Empty Folders – Stop Originally Posted…

Read More