如何在另一个计算列中使用一个计算列

问题描述

你好

我想在其中有两个计算列的表下面创建表，但是在创建表时出现错误，msg ,,,,

hello

I want to create table below table in which i have two computed column ,but there are some error msg while creating table,,,,,

CREATE TABLE [tblcaseprogress_old](
    [Et_id] [int] NOT NULL,
    [u_id] [int] NOT NULL,
    [registration] [int] NULL,
    [contact] [int] NULL,
    [property] [int] NULL,
    [expense] [int] NULL,
    [income] [int] NULL,
    [asset] [int] NULL,
    [liability] [int] NULL,
    [qa] [int] NULL,
    [hardship] [int] NULL,
    [suppdoc] [int] NULL,
    [rvsub] [int] NULL,
    [cobor] [int] NULL,
    [empinfo] [int] NULL,
    [financial] AS ((([income]+[expense])+[asset])+[liability]),
    [total]  AS ((((((([registration]+[contact])+[property])+[financial])+[qa])+[hardship])+[suppdoc])+[rvsub])
) ON [PRIMARY]

错误:
表"tblcaseprogress_old"中的计算列"financial"不允许在另一个计算列定义中使用.



我这边有什么问题，请给我建议...

Error:
Computed column ''financial'' in table ''tblcaseprogress_old'' is not allowed to be used in another computed-column definition.



anything wrong from mine side,plz suggest me...

推荐答案

CREATE TABLE [tblcaseprogress_old](
    [Et_id] [int] NOT NULL,
    [u_id] [int] NOT NULL,
    [registration] [int] NULL,
    [contact] [int] NULL,
    [property] [int] NULL,
    [expense] [int] NULL,
    [income] [int] NULL,
    [asset] [int] NULL,
    [liability] [int] NULL,
    [qa] [int] NULL,
    [hardship] [int] NULL,
    [suppdoc] [int] NULL,
    [rvsub] [int] NULL,
    [cobor] [int] NULL,
    [empinfo] [int] NULL,
    [financial] AS ((([income]+[expense])+[asset])+[liability]),
    [total]  AS ((((((([registration]+[contact])+[property])+((([income]+[expense])+[asset])+[liability]))+[qa])+[hardship])+[suppdoc])+[rvsub])
) ON [PRIMARY]

这篇关于如何在另一个计算列中使用一个计算列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！