Posts

Showing posts from September 27, 2012

Database Experts:Add New Column in All Tables that don' t have column with specific data types

Image
Sometimes we need some columns that usually used by for row insert and update information. For E.g. CreatedBy,ModifiedBy etc.. Just Execute below Stored Procedure to Add column to all tables that don't have this column. /******************************************************************************/ /* Copyright: 2012 Database Experts * * Name :[Add_New_Column] * Version : $Revision: 1 * Created By : $Author: Database Experts * Modified By : $Author: * Script : This Procedure will create new column with specific data type. * Input: 1. @Column_Name,@Data_Type * * Output: * Version Info: * No.                 Author                            Date                                                           Comments * --- ------ ---- -------- */ /*****************************************************************************/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE Procedure [dbo].[Add_New_Column]     @Column_Name varchar(50),     @Da