Posted by Tony Rogerson on 10/01/73 11:41

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
>

• Next in forum: Re: Script to reverse engineering schema
• Prev in forum: how to call a stored procedure in an insert command
• Thread view: Re: how to call a stored procedure in an insert command

[Reply to this message]