Solved

select statement - withou null value

Posted on 2011-02-11
3
262 Views
Last Modified: 2012-06-22
I have a table which contain 73 fields. I don't want to get any fileds that has null value. How could I query it?

select *from table1 where field1 in not null, etc. One at a time?  Is there a better way?
0
Comment
Question by:VBdotnet2005
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
Rick earned 125 total points
ID: 34875810
select * from table
where field1 is not null
     and field2 is not null
     and field3 is not null

No better way.
0
 

Author Comment

by:VBdotnet2005
ID: 34875918
ok. Is there a way to get field(73) just header in one shot?
0
 

Author Comment

by:VBdotnet2005
ID: 34875933
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now