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 |
|
scottichrosaviakosmos
Yak Posting Veteran
66 Posts |
 Posted - 2010-08-26 : 09:06:41
|
| i have a table and i am writing a procedure. my table has a unique column eg:u_column .Now, i want to know on which u_column its which columns are null or no values and to select those blank columns and show in resultset.scoo |
|
|
Langthasa
Starting Member
6 Posts |
Posted - 2010-08-26 : 09:24:09
|
| Hi,you can give the condition in where clause u_column is Null for all Null values and for Blank column jst give u_column=''like Where u_column is Null or u_column='' |
 |
|
|
scottichrosaviakosmos
Yak Posting Veteran
66 Posts |
Posted - 2010-08-26 : 09:29:07
|
| no no,I dont want to check null or not for this column but i want to find on basis of this unique column which all columns in this specific row is null and select those blank columns and display.scoo |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-26 : 11:11:09
|
| didnt get that. can you elaborate with sample data please?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
find columns with null value