使数据库的一列自动求和 如何使数据其中一列自动按一定的公式求解的谢谢例如AmountValue=UnitAvalue*TheoryAmountAmountValue这一列当其余两列生成数据后自动求解 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 CREATE TABLE [dbo].[Table_1]( [a] [int] NULL, [b] [int] NULL, [c] AS ([a]*[b])) 数据类型不是int如何设计公式 CREATE TABLE [dbo].[Table_1]( [a] varchar(10) NULL, [b] varchar(10) NULL, [c] AS cast([a] as int)*cast([b] as int)) ---引用楼上一下CREATE TABLE [dbo].[Table_1]( [a] varchar(10) NULL, [b] varchar(10) NULL, [c] AS cast([a] as int)*cast([b] as int))insert into [Table_1] values(1,2)insert into [Table_1] values(10,20)insert into [Table_1] values(11,22)select * from [Table_1]a b c---------- ---------- -----------1 2 210 20 20011 22 242(3 行受影响) 或者新建一个视图,增加一列Create VIEW VW_Table_1 AS SELECT [a],[b],cast([a] as int)*cast([b] as int) AS [AB] FROM Table_1 如果是固定等于其它两列的乘积,为什么不放到程序的实体里能过get访问器来实现呢 [c] AS ([a]+[b]) 字段中字符的期望的长度为何和len不一样? sql语句 在配置发布、分发服务器时出错! 求一数据汇总的SQL语句 请教一sql语句,在线等 为什么我的机子重装win2000 pro以后,SQL server 2000就装不上了? 请大家来谈谈图片上传的经验,我的这么简单实现,为什么邹老大那么复杂,我的不足处,请指出! 关于sql server 2000发邮件的问题 请教各位,关于建表时默认值的问题? 如何调用事务日志 关于SQL视图的疑问 SQL函数中判断一个字符串是否为空
[a] [int] NULL,
[b] [int] NULL,
[c] AS ([a]*[b])
)
数据类型不是int如何设计公式
[a] varchar(10) NULL,
[b] varchar(10) NULL,
[c] AS cast([a] as int)*cast([b] as int)
)
---引用楼上一下
CREATE TABLE [dbo].[Table_1](
[a] varchar(10) NULL,
[b] varchar(10) NULL,
[c] AS cast([a] as int)*cast([b] as int)
)insert into [Table_1] values(1,2)
insert into [Table_1] values(10,20)
insert into [Table_1] values(11,22)select * from [Table_1]a b c
---------- ---------- -----------
1 2 2
10 20 200
11 22 242(3 行受影响)
或者新建一个视图,增加一列Create VIEW VW_Table_1 AS
SELECT [a],[b],cast([a] as int)*cast([b] as int) AS [AB]
FROM Table_1