sql insert into a table with computed columns

Question

I have a table with 4 columns, say COLA,COLB,COLC,COLD. COLC and COLD are computed columns. Suppose I want to insert a row into table, should the query be something like

insert into Table (COLA,COLB,COLC,COLD) values (1,2,'','')?

I know I can't insert into computed columns. But how can I add a row and keep the default computed columns as they are?

Thanks for any advice!

computed columns need not be considered in the insert statement. — Mahesh Sambu, Mar 25 '14 at 18:01

score 5 · Answer 1 · edited Nov 12 '20 at 04:47

5

try this

    INSERT INTO TABLE (COLA,COLB) values (1,2);

you dont need to provide the values even blanks for computed column. They get calculated automatically

edited Nov 12 '20 at 04:47

sonique

4,539
2
30
39

answered Mar 25 '14 at 18:01

Avinash patil

1,689
4
17
39

Does this work when the computed column has been defined as a not null column? – Gerald LeRoy Sep 26 '22 at 22:05

score 1 · Answer 2 · answered Mar 25 '14 at 18:01

1

Just specify the columns you want to insert values into:

insert into Table (COLA,COLB) values (1,2)

answered Mar 25 '14 at 18:01

Stuart Ainsworth

12,792
41
46

score 1 · Answer 3 · answered Mar 25 '14 at 18:02

1

Just don't specify the calculated columns:

insert into Table (COLA,COLB) values (1,2)

answered Mar 25 '14 at 18:02

Philip Kelley

39,426
11
57
92

score 0 · Answer 4 · answered Mar 25 '14 at 18:05

0

Thank you all! I just got that out too! Previously I got errors that number of col don't match, because I missed a a column.

answered Mar 25 '14 at 18:05

user3344443

475
2
11
29

sql insert into a table with computed columns

4 Answers4

Linked