Thursday, November 21, 2013

SQL Server Possible Order By Bug

Hello Mike.


Is there a "right way" and a "wrong way" to initialize variables?


What about this link: http://technet.microsoft.com/en-us/library/ms187330.aspx? Isn't it official? Does not express the official point of view of Microsoft about the usage of variables inside the SELECT?


I do believe it is a bug, as also was stated by Cristoph. This post was definitely not about concatenation of the strings, which you brought into discussion for I do not know which reason.


I disagree with the fact that such kind of "side effect" as you call it is not a bug. Then why at compile time the side effects encountered in functions are completely forbidden and this is not?


I always thought that the result should be correct or an error should be thrown.


If the discussion goes into better or worse ways to do things I always have thought it should be subject to some best practice documents.


Are you absolutely sure your post is OK and I deserve what you have said about my post? My feeling is that you jumped on me too soon, and I take in advance all the blame for my feeling if wrong.


No comments:

Post a Comment