Gregory's Server
Out of curiosity: Did you know SQL can have case sensitive column names?
Boost for reach if that's your thing.
Anonymous poll
Poll
Yes
81
39.9%
No
39
19.2%
What?
69
34%
Show me the answers!
203 people voted. 14
6.9%
Voting ended 22 August at 14:23.
@dpflug also suffered because of it (having to put my select * from "Users" between quotations :angery: )
@dpflug
And, as of a few years ago anyway (pre-SQL 2019 at least?), column mappings in SqlBulkCopy are case sensitive regardless of how the tables are set. And the error message is incredibly unhelpful.