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 25, 2017 at 9:11 | history | tweeted | twitter.com/StackDBAs/status/845563880424308736 | ||
| Mar 14, 2017 at 17:53 | vote | accept | Andis59 | ||
| Mar 14, 2017 at 13:42 | answer | added | Nelson | timeline score: 1 | |
| Mar 14, 2017 at 13:39 | comment | added | McNets | You must deal with dynamic queries. | |
| Mar 14, 2017 at 13:26 | history | edited | Andis59 |
specify which server
|
|
| Mar 14, 2017 at 13:25 | comment | added | Andis59 | Not according to Microsoft! SQL Server follows the ANSI/ISO SQL-92 specification (Section 8.2, , General rules #3) on how to compare strings with spaces. The ANSI standard requires padding for the character strings used in comparisons so that their lengths match before comparing them. The padding directly affects the semantics of WHERE and HAVING clause predicates and other Transact-SQL string comparisons. For example, Transact-SQL considers the strings 'abc' and 'abc ' to be equivalent for most comparison operations. | |
| Mar 14, 2017 at 13:04 | history | asked | Andis59 | CC BY-SA 3.0 |