The other day I was running some code and the variable that I created was not being populated. I looked at the code for a minute or so, ran it again (like that would change it) and it was still null. Before I show you the code, I want you to look at this image, what do you see?
The way this works is that your brain eliminates the second the since it already processed.
Take a look at this text below, you probably have no problem "reading" it
"I cdn'uolt blveiee taht I cluod aulaclty uesdnatnrd waht I was rdanieg: the phaonmneel pweor of the hmuan mnid. Aoccdrnig to a rseearch taem at Cmabrigde Uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoatnt tihng is taht the frist and lsat ltteer be in the rghit pclae. The rset can be a taotl mses and you can sitll raed it wouthit a porbelm. Tihs is bcuseae the huamn mnid deos not raed ervey lteter by istlef, but the wrod as a wlohe. Scuh a cdonition is arppoiatrely cllaed Typoglycemia .
"Amzanig huh? Yaeh and you awlyas thguoht slpeling was ipmorantt."
So back to my code..here is a simple example
Do you see the problem? The table has a column named name, the variable is @name, these look very similar
Let's take a look at another example, one of my co-workers was inserting data into a temp table from another table.
He then needed to add a column, he modified the temp table to add this column, then he added this column to his insert query, the column name was pack_sent
Running that gave him this error
Msg 213, Level 16, State 1, Line 1
Column name or number of supplied values does not match table definition.
Do you see what happened? He added the column but forgot a comma, so pack_sent became an alias for the pack_received column. Sometimes I really wished as would be required to alias a column, at least you could eliminate errors like these,
So how many times have you done stuff like this..also do you have any other examples of similar stuff?