how to call a stored procedure in an insert command

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

create proc get_your_calc
as
begin
select a, b, total = a + b
from yyy

end


--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"satish" <satishkumar.gourabathina@gmail.com> wrote in message
news:1140593950.858980.60120@g44g2000cwa.googlegroups.com...
> 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
>