|
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
>
[Back to original message]
|