SQL中如何批量修改字段类类型

minybo

alter table s_private alter column sale_18_1 int
alter table s_private alter column sale_18_2 int
alter table s_private alter column sale_18_3 int
alter table s_private alter column sale_18_4 int
alter table s_private alter column sale_18_5 int
alter table s_private alter column sale_18_6 int
alter table s_private alter column sale_18_7 int
alter table s_private alter column sale_18_8 int
alter table s_private alter column sale_18_9 int
alter table s_private alter column sale_18_10 int
alter table s_private alter column sale_18_11 int
alter table s_private alter column sale_18_12 int
alter table s_private alter column sale_19_1 int
alter table s_private alter column sale_19_2 int
alter table s_private alter column sale_19_3 int
alter table s_private alter column sale_19_4 int

minybo

我只会这种最笨的方法，想求教下如何批处理？用通配符或者循环或者过程处理都行，但是不会，求教~