Tuesday, September 13, 2011

ALTER TABLE ADD MULTIPLE COLUMNS IN SQL - SQL TIPS

ALTER TABLE ADD MULTIPLE COLUMNS - SQL

How to add multiple columns in single alter statement in sql?


ALTER TABLE Employee
ADD
ContactNo varchar(50),
MobileNo varchar(50),
Email varchar(50),
ReEnterEmail varchar(50);

Hope this tip will be helpful...Feel free to comment...

All Rights Reserved DotNetAnna | Blogger Template by Bloggermint