Database Experts:Add New Column in All Tables that don' t have column with specific data types
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 ...