I have a database with about 40 tables in, and I'd like to replace most of these null values with blanks, as they're messing up my stored procedures. so my questions are:
1 - is there a way of searching every table in the database, and reporting all columns which contain at least one null velue?
1a - if not, could I do it on each table one by one - eg "select * from table where "any column" is null
2 - once I've done this is there any way of replacing all the null values in a database with "blank"
2a - or doing this at an individual table level?
View Complete Post