Update the value back

leoraja8 · #1 (**permalink**) 09-25-2007, 11:51 PM

Hi there,

I'm new to SQL Server 2005 and stored procedure.

I want a simple logic to be done using store procedure.

I select a field from a table with multiple rows of records, then later I update the value back to the same field after calculation. How can i do that?

S.Vinothkumar · #2 (**permalink**) 09-26-2007, 03:38 AM

Hey Leo,

Use my coding as following,

Code:

Declare MyCur Cursor

For

Select name,age From emp --- your query here 


Open MyCur

Declare @UserName Varchar(50)

Declare @Age int 
 

Fetch Next From Cursor Into @UserName, @Age

 

            While @@Fetch_Status = 0

             Begin 

 		Update emp set age = @Age *2 where [name]= @UserName -- do your calculation here 


             End


Close MyCur

Deallocate MyCur

krishnakumar · #3 (**permalink**) 09-27-2007, 03:03 AM

Hi there,

I think the cursor is not necessary here.

For all records in the table:

Code:

UPDATE employee
SET age = age + 1

this will increment all employee ages by one.

or, if we are being more precise:

Code:

UPDATE employee
SET pay_grade = pay_grade + 1
WHERE department = 'Sales'

this will increase the pay grade for all sales employees.

leoraja8 · #4 (**permalink**) 09-27-2007, 03:49 AM

thnx vinoth,

It's work for my wish....

S.Vinothkumar · #5 (**permalink**) 09-27-2007, 04:21 AM

So...have a glad for your problem solved.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Back Links and PR Update	muller	Google	1	09-29-2008 05:34 AM
Great to be back!	WiccanSpirit	The Lounge	4	02-18-2008 02:23 AM
Back End testing	simplesabita	Software Testing	1	10-30-2007 03:49 AM
BACK inAjax	jegan	PHP Programming	2	08-06-2007 03:49 AM
Disable Back Button	ewriter	HTML, CSS and Javascript Coding Techniques	1	04-24-2007 11:16 PM