How to ALTER or ADD two columns in Sql Server Table using T-Sql

Introduction

In this tips, I will explain how to ALTER or ADD two or more columns in to table by t-sql script..Sometimes we may need to modify existing table structure in database, but we may be not access design view of the table. Hence this time we can use the T-Sql to ADD or ALTER more columns into table using T-Sql.

Example

In example, going to add two to existing Employee table,

ALTER TABLE T_Employee ADD
[Salary] [decimal] (18, 3) NULL,
[Bouns] [decimal] (18, 3) NULL

That's all. now you can alter that existing table usign T-Sql with one or more columns.thank you for reading.