Solved

select statement - withou null value

Posted on 2011-02-11
3
281 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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 information from SQL Server on Database, Connection and Server properties

808 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