各高手小的来向你们请教一个问题哦,SQL 2000中有一张商品销售表用来存储商品的销售记录的,其中有一个字段为商品的销售价格(mer_sell_price),还有一个字段为商品销售数量(mer_sell_num),现在我想用另一个字段(mer_sell_total)来存储(mer_sell_price)*(mer_sell_num)的乘积,请问在设计表中,字段(mer_sell_total)的默认值的代码应该是什么呢?我先谢谢拉~~~~~
调试欢乐多
create table ta(mer_sell_price decimal(15,2),mer_sell_num int,mer_sell_total as mer_sell_price*mer_sell_num )insert ta
select '20',5select * from ta
mer_sell_price mer_sell_num mer_sell_total
----------------- ------------ ----------------------------
20.00 5 100.00(所影响的行数为 1 行)
eg:
create table test
(a int,b int, c as a*b)insert test select 1,2select * from test
drop table test
create table tb(
mer_sell_price decimal(10, 2),
mer_sell_num int,
mer_sell_total as mer_sell_price*mer_sell_num --计算列
)insert tb(mer_sell_price, mer_sell_num) select 10.2, 8select * from tbdrop table tb