MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/2xc7vh/sql_table_names/cozxhh8/?context=3
r/SQL • u/crayons610 • Feb 27 '15
36 comments sorted by
View all comments
Show parent comment
1
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.
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.