How to increment the value

Question

How to increment the value

Suresh Mediboyina-615840

Valued Member

Points: 61
More actions
December 6, 2009 at 10:22 pm

#96350

Hi Sql Gurus,
I'm new to queries, I need update sal column with 10% increment of the sal whose age 45years.In the table s.No, Name, sal, DOB (dateofBirth), DOJ (dateofjoin), are the columns, table having 1000 records,
How can update table,
Regards,
Suresh Mediboyina

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 1

Have you not run any update statement yet? This is a simple update statement that should have been known by a beginner in T-SQL for that matter a Starter in SQL Server.

Please find example on Google for update SQL Server Statements...

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Nabha SSCrazy Eights Points: 8534 More actions · Answer 2

See if this helps, (A recent article on different ways of update)

http://www.sqlservercentral.com/articles/cursor/68478/

---------------------------------------------------------------------------------