Timeline for How change space only columns to null
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 14, 2017 at 17:53 | vote | accept | Andis59 | ||
| Mar 14, 2017 at 14:16 | history | edited | Nelson | CC BY-SA 3.0 |
added 55 characters in body
|
| Mar 14, 2017 at 14:03 | comment | added | Nelson | I just turned null safe, didn't attempt to cover all the bases but to deal with the main subject is there a way that I can use a list of tables and a list of columns and do this for all without writing a query for each : ) | |
| Mar 14, 2017 at 14:02 | history | edited | Nelson | CC BY-SA 3.0 |
turn null safe
|
| Mar 14, 2017 at 13:54 | comment | added | Hannah Vernon♦ |
You probably should not use the INFORMATION_SCHEMA views; use the system DMVs instead, such as sys.columns. Also, if a column is defined as NOT NULL, this code will generate an error.
|
|
| Mar 14, 2017 at 13:52 | history | edited | Nelson | CC BY-SA 3.0 |
added 112 characters in body
|
| Mar 14, 2017 at 13:42 | history | answered | Nelson | CC BY-SA 3.0 |