Question

asp.net 数据库同一个表内的变量相加 怎么写

rs("guo")=guo
rs("dishui")=dishui
rs("gongshang")=gongshang
rs("gongben")=gongben
rs("qita")=qita
rs("tel")=tel
rs("shui")=shui
rs("gongzi")=gongzi
rs("wang")=wang
rs("cai")=cai
rs("ti")=ti
rs("zichan")=zichan
rs("zhangzhu")=zhangzhu
rs("shangchang")=shangchang
rs("gongsi")=gongsi
rs("yun")=yun
rs("ding")=ding
rs("she")=she
rs("fangwu")=fangwu
rs("jiameng")=jiameng
rs("huo")=huo
rs("yin")=yin
rs("weisheng")=weisheng
rs("guang")=guang
rs("guanli")=guanli
rs("zhuang")=zhuang
rs("bizhu")=bizhu
rs("nian")=year(Now())
rs("yue")=Month(Now())
rs("zhou")=date(Now())
rs("ri")=day(Now())
rs("ren")=session("AdminName")
rs("data")=now
rs("zong")=guo+dishui+gongshang+gongben+qita+tel+shui+gongzi+wang+cai+ti+zichan+zhangzhu+shangchang+gongsi+yun+ding+she+fangwu+jiameng+huo+yin+weisheng+guang+guanli+zhuang
rs.update

Answer 1

没懂你题的意思,说详细点吧

是不是这样:
update 表名 set 列名=列名 + 常量 where 条件