Not sure about Sql, but in C# you can make an sql statement that will do it. First get all of your column names for that table, next loop through your data and add on your clause. So, in psuedo code:
select column names from your table.
initialize your dynamic sql string to: "select * from table where ";
for each column
// here you add on the not null and != 0 part
sql += column + " is not null and " + column + " != 0 AND "
I can write it up in actual syntax, but I think that gets the point accross.
private string generateSQL(string strTable)
string strSql = "select * from " + strTable + " where ";
SqlConnection con = new SqlConnection(@"your con");
SqlCommand command = new SqlCommand("select COLUMN_NAME From yourDB.Information_Schema.Columns where table_name = '" + strTable + "'", con);
reader = command.ExecuteReader();
strSql += reader.GetString(0) + " IS NOT NULL AND " + reader.GetString(0) + " != 0 AND ";
return strSql.Substring(0, strSql.Length -4);
string strTest = generateSQL("tbl");
Watch out for datatype issues on the != 0 part.