saikatrana

 Profile Answers by saikatrana 

• Feb 1st, 2009

 

If you want to update a base table you will have to run this command.
Suppose, my
base table is Student & its columns are Name&Age, then use this command to update:

update student
set Name='Graham',
Age=30;

Then all the records of the table will be updated containing name as "Graham'' & Age as 30
If you want to update only your desired columns against a defined column value follow the statement written below:

update student
set Name='Graham',
Age=30
where name='Carey';

taraldesai

 Profile Answers by taraldesai 

• Mar 4th, 2009

 

Provide clear scenerio what you want to achieve with example

monika_iims

 Profile Answers by monika_iims 

• Jun 18th, 2010

 

1.create a procedure with update statement
2. create a job on that procedure and give the time interval