maxiee

• Jun 24th, 2005

 

It will update all the records with same name in the particular field of the table.

Krishna

• Sep 1st, 2005

 

If we dont mwntion "WHERE" clause in the UPDATE statement, it will update all records satisfying the given condition (if given any ) in the table !

tallamnagesh

 Profile Answers by tallamnagesh 

• Jun 24th, 2006

 

Based on query condition. it wil update all the fields which are mentioned in the query.

ex: update employee set firstname= @firstname,lastname=@lastname where employee_id =@employee_id.

so in the above case nothing wil be happen if you used where clause or not.

if you have  many statements in the query u need to use the where clause.