UPDATE command question - 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

SQL Server 2005 Forums

Transact-SQL (2005)

UPDATE command question

Author

Topic

skiabox
Posting Yak Master

169 Posts

Posted - 2008-12-11 : 02:54:18

Can the update command be used to enter values in null cells?
Thank you very much.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-11 : 02:57:15

Yup. something like

UPDATE Table
SET Field1=newvalue,
Field2=NULL,...

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2008-12-12 : 00:52:45

update yourtable
set columnname = newvalue
where columnname is null

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources