StockNum 字段在数据表里,是int型,默认为null,
因此在做字段相加时,要加IsNull()判断,否则为Null值时,无法进行相加;
例如:
Update Member set StockNum = StockNum + 1 (错误的写法)
这样写是错误的,
应该为:
Update Member set
StockNum = IsNull(StockNum,'0') + 1
StockNum 字段在数据表里,是int型,默认为null,
因此在做字段相加时,要加IsNull()判断,否则为Null值时,无法进行相加;
例如:
Update Member set StockNum = StockNum + 1 (错误的写法)
这样写是错误的,
应该为:
Update Member set
StockNum = IsNull(StockNum,'0') + 1