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.
| Author |
Topic |
|
ovince
Starting Member
32 Posts |
 Posted - 2006-11-10 : 04:45:47
|
| hi,I found this select * from delTest where plate is nullas a nice tool to find NULL values in one column. What if I have a table with many columns? Is there a way to find rows with NULL? I mean, I am sure that there is a way but donk now it many thanksOliver |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-10 : 04:56:18
|
Clearly you will have to check each column for NULL in the same way:Select * from TblWhere col1 is null or col2 is null or col3 is null... Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
ovince
Starting Member
32 Posts |
Posted - 2006-11-10 : 05:07:22
|
| so for 1000 column-table 1000 OR commands? Is it posible? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-10 : 05:23:04
|
| For a 1000-column table, you need to redesign your system.Peter LarssonHelsingborg, Sweden |
|
|
|
ovince
Starting Member
32 Posts |
Posted - 2006-11-10 : 05:33:57
|
| :))))) Kettö sör for this also Peter |
|
|
|
|
|
|
serching NULLs