create or alter table sql code example

Example 1: create column sql server

ALTER TABLE table_name
ADD column_name datatype;

Example 2: sql server 2012 create or alter procedure

IF OBJECT_ID('spCallSomething') IS NULL
    EXEC('CREATE PROCEDURE spCallSomething AS SET NOCOUNT ON;')
GO

ALTER PROCEDURE spCallSomething ... 
--instead of DROP/CREATE