怎样给数据库里的表增加列

给数据库里的表增加列，我用的这个命令，运行就把所有补充的列补充上了。挺快

alter table ERPuser1 add  [ZhiCheng] [varchar](50) ,
[BiYeYuanXiao] [varchar](50) NULL,
[ZhuanYe] [varchar](50) NULL,
[CanJiaGongZuoTime] [varchar](50) NULL,
[JiaRuBenDanWeiTime] [varchar](50) NULL,
[JiaTingDianHua] [varchar](50) NULL,
[JiaTingAddress] [varchar](500) NULL,
[GangWeiBianDong] [text] NULL,
[JiaoYueBeiJing] [text] NULL,
[GongZuoJianLi] [text] NULL,
[SheHuiGuanXi] [text] NULL,
[JiangChengJiLu] [text] NULL,
[ZhiWuQingKuang] [text] NULL,
[PeiXunJiLu] [text] NULL,
[POP3Server] [varchar](50) NULL,
[POP3Port] [varchar](50) NULL,
[SMTPUserName] [varchar](50) NULL,
[SMTPUserPwd] [varchar](50) NULL,
[SMTPServer] [varchar](50) NULL,
[SMTPFromEmail] [varchar](50) NULL,
[TiXingTime] [varchar](50) NULL,
[IfTiXing] [varchar](50) NULL,
[DaoHangList] [text] NULL,
[xKeGuanDep] [varchar](5000) NULL,
[XiaShuUser] [varchar](8000) NULL