Updation of a Table Having NULL value

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)

Updation of a Table Having NULL value

Author

Topic

Sudha1234567
Starting Member

5 Posts

Posted - 2009-08-31 : 09:46:40

Update a table having NULL Value

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-08-31 : 09:49:24

quote:
Originally posted by Sudha1234567

Update a table having NULL Value

Update table
set col='some value'
where col is null

Madhivanan

Failing to plan is Planning to fail

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2009-08-31 : 09:49:38

You mean a record?

Update sometable set SomeColumn = 'somevalue' where somecolumn is null

An infinite universe is the ultimate cartesian product.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources