Need to identify columns that have Null Values.

  • I'm having trouble Serializing my LinqDB while trying to Save my web session state to an MS Sql Db.

    I receive errors for trying to serialize Null Values. The long and short of the problem is that I need to identify columns that have Null Values, so that I can eliminate them.

    To that end, if I could run some utility that identified rows that contain nulls (telling me which column(s)), then I could address the issue.

    In an ideal world, such a procedure would execute on the entire Database, Identifying Which Table, row, and column that contains a null value.

  • Why dont you just do a query for WHERE Column is null or do you have hundreds of columns in your DB?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply