delete a row with by finding a NULL value in colum

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 2000 Forums

Transact-SQL (2000)

delete a row with by finding a NULL value in colum

Author

Topic

sqlWhat
Starting Member

12 Posts

Posted - 2006-10-11 : 11:44:10

I posted previously of my woes of inserting extra data into the database I delete a good portion of the rows but not I need to get rid of the rwos that have a NULL value in a certain column in the table

Thanks again for the help

nr
SQLTeam MVY

12543 Posts

Posted - 2006-10-11 : 12:06:30

Not sure what the question is but you have to use
where col is null
rather than
where col = null (returns null which is interpreted as false)

and for joins
where (col1 is null and col2 is null)
rather than
where col1 = col2

more completely
where (col1 = col2 or (col1 is null and col2 is null))

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

sqlWhat
Starting Member

12 Posts

Posted - 2006-10-11 : 12:16:48

nr

Thanks a ton did not think of that much appreciated. That did the trick. AWSOME

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources