Posted by satish on 06/13/50 11:41

hi,
i had a small doubt , i have a table xxx with two columns (a int,b int
) and i have inserted 5 rows my query is to add the two colums using a
stored procedure and the result has to be displayed in an separate
column --this has to be done only stored procedures ---i know how to
solve the problem using computed columns concept

like this

create table yyy(a int ,b int ,total as a+b)

insert into yyy values (12,13)
select * from yyy

i need the answer using stored procedures---is it possible

pls help me
satish

• Next in forum: Re: how to call a stored procedure in an insert command
• Prev in forum: Re: Select command with multiple tables
• Thread view: how to call a stored procedure in an insert command

[Reply to this message]