常用sql模板

1. 修改表结构

          a.  增加列

use hswinrun2
go
if  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 hswinlog2
go
if  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_info
end 
go

        c 修改列字段长度 

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

  d 修改默认值

alter table dictateinfoex add default (0) for l_approve_operator_2 with values