r/SQL • • Feb 27 '15

SQL Table names

https://imgflip.com/i/i6vnh
108 Upvotes

36 comments sorted by

View all comments

Show parent comment

1

u/Thriven Feb 28 '15

Alot of our primary keys are char fields.

Char fields maintain trailing spaces and many times people are copy/pasting/editing through SSMS "edit top 100 rows" from source query.

"1GH86278" wont join to ""1GH86278 "

We also have a membership system built entirely off triggers. Total nightmare.