Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/5/d280432743/htdocs/wp-content/plugins/jetpack/_inc/lib/class.media-summary.php on line 77

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/5/d280432743/htdocs/wp-content/plugins/jetpack/_inc/lib/class.media-summary.php on line 87
Checking Type mismatch in Recursive CTE - Collation at fault - Ben Foster
Checking Type mismatch in Recursive CTE – Collation at fault

Checking Type mismatch in Recursive CTE – Collation at fault

Took me a while to figure out why there was a type mismatch in a CTE I was writing for in a query the other day, always think about collation, because although it’s in the background for most of the time it can always crop up when you least expect it!

http://consultingblogs.emc.com/paulmcmillan/archive/2011/01/07/sql-collation-gotcha-1-recursive-cte.aspx

Comments are closed.