常用sql模板

1. 修改表结构

          a.  增加列

use hswinrun2goif  not exists (select 1 from syscolumns where id = object_id('stockcodesex') and name = 'c_stock_invest_type')begin    print '合同信息表 hswinrun2.dbo.stockcodesex 增加c_stock_invest_type列'    alter table hswinrun2.dbo.stockcodesex  add c_stock_invest_type varchar(1)end go

          b.删除列

use hswinlog2goif  exists (select 1 from syscolumns where id = object_id('interfacelog_xd') and name = 'vc_error_info')begin    print '信贷接口日志表 hswinlog2.dbo.interfacelog_xd 删除vc_error_info列'    alter table hswinlog2.dbo.interfacelog_xd  drop column vc_error_infoend go

        c 修改列字段长度 

alter table hswinrun2.dbo.loanrival alter column vc_rival_detail varchar(1)