Update query error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Update query error

Author

Topic

spinoza
Starting Member

49 Posts

Posted - 2006-01-22 : 06:38:20

I am trying to set a particular field with the same value...I am using the following formula

update jokes
set author='Marym'
where jokes_id = 567 or 568

but i am receiving an error... I can do it using one joke_id but not when I try to implement it for 2 or more like above...

Any help for the syntax of the above query??

Nazim
A custom title

1408 Posts

Posted - 2006-01-22 : 06:47:57

update jokes
set author='Marym'
where jokes_id in(567 ,568 )

or

update jokes
set author='Marym'
where jokes_id = 567 or jokes_id=568

-------------------------
What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson

spinoza
Starting Member

49 Posts

Posted - 2006-01-22 : 07:06:54

Gracias Nazim :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources