Posted by undercups on 09/22/06 21:06

CREATE table ><>>> Look at computered columns is your answer . BTW no
data is stored for this type of column.

e.g. CREATE TABLE mytable
(
low int,
high int,
myavg AS (low + high)/2


Duncan

• Next in forum: Re: Insert trigger to populate other columns in same row
• Prev in forum: Insert trigger to populate other columns in same row
• Thread view: Re: Insert trigger to populate other columns in same row

[Reply to this message]