Viewing 15 posts - 1 through 15 (of 656 total)
Why would anyone want to turn off standard ANSI defaults? I thought these options were a legacy thing. Or is there some real reason to sue them still that I'm...
February 20, 2023 at 9:08 am
The reason for the restriction is (I assume) that it needs some way of determining datatype. So this will also work:
select case when 1=0 then cast(null as...
January 23, 2023 at 8:28 am
I was looking for option 5, the developer who coded this is now looking for a new job 😉
September 20, 2022 at 7:14 am
Can anyone think of any real life examples where you'd want to rank over something non-unique?
July 11, 2022 at 7:34 am
A very valid question I thought, but one that's more about NOLOCK than EXCEPT, and the explanation should have included the comments later added.
June 8, 2022 at 7:09 am
What's "crazy" isn't the final sign. It's that SQL doesn't recognize unary minus. In math, and in every ordinary programming language I've ever encountered, unary operators have higher precedence...
June 9, 2020 at 12:54 pm
I don't really understand the explanation. In what was is anything "crazy" about the handling of negatives? Whatever the precedence you end up dividing a negative by a negative, which...
June 9, 2020 at 7:16 am
Not to nit-pick, but the option is actually called ANSI_NULL_DFLT_OFF, so technically, all the answers are incorrect.
However, the database option is called ANSI_NULL_DEFAULT, which can be set to OFF...
November 25, 2019 at 9:09 am
However, if it were a varchar
, why would you be converting it to a varchar
..? Style codes only affected when convert to or from a varchar
from another data type....
October 25, 2019 at 11:01 am
The answer depends on the data type of dbo.SalesHeader.OrderDate. If it's a datetime or similar then the answer is 6 as given. But if it's a varchar column then the...
October 25, 2019 at 10:31 am
None of the answers is correct. You can index a computed column based on a float as long as it is persisted.
October 15, 2019 at 9:02 am
Ignoring the fact that the dates are a week apart 😉
I did a search before replying and that told me that Colorado is also on daylight savings time in May,...
May 21, 2019 at 8:55 am
Guessed right but for the wrong reason.
Must admit, I don't quite see the point in teaching us about a feature that most of us have probably never heard of...
February 8, 2019 at 1:52 am
Stewart "Arturius" Campbell - Thursday, January 10, 2019 12:09 AMNice, easy question, thanks Steve
Easy until I checked the documentation to "confirm" what...
January 10, 2019 at 4:22 am
December 6, 2018 at 3:43 am
Viewing 15 posts - 1 through 15 (of 656 total)