Ed Wagner (1/29/2015)
GilaMonster (1/29/2015)
Brandie Tarvin (1/29/2015)
That what will soon be illegal in SQL? (You have an unclear antecedent for the second "that" in your edited comment.)The omission of the WITH on the nolock hint. Might be others, but that's the one I know about. Been deprecated for a while.
So will the omission of the semicolon at the end of a statement. I noticed that the SET statement above doesn't have one. I have a feeling that this one will impact a lot of people.
I suspect that the missing WITH will break long before ; is required everywhere.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability