Trailing Space Behavior

Kevin Feasel

2017-04-14

T-SQL

Brent Ozar shows how SQL Server deals with trailing spaces in columns:

The mind-blowing part to me is the <> operator – that seemed utterly crazy to me.

And if you add another table, and join to it, guess what happens:

The answer might be a bit surprising.

Related Posts

New T-SQL Functions

Dennes Torres shows off four T-SQL functions releasing in SQL Server 2017: Translate Translate does the work of several replace functions, simplifying some queries. The function is called ‘Translate’ because its main objective: transform one kind of information in another by doing a bunch of replaces. For example: GeoJson and WKT are two different formats […]

Read More

Ditching IsNumeric()

Phil Factor on the IsNumeric() function: IsNumeric() is actually answering the question ‘Can this string be converted or ‘cast’ to a numeric datatype by SQL Server?’ It is pretty good at getting this answer right but it doesn’t tell you which datatype. It also isn’t interested in such things as overflow. This problem of IsNumeric() […]

Read More

Categories

April 2017
MTWTFSS
« Mar May »
 12
3456789
10111213141516
17181920212223
24252627282930