Viewing 15 posts - 1 through 15 (of 209 total)
Thank you to Tonie and Jeffrey for explaining this to me ... I was completely wrong!
February 20, 2025 at 8:10 am
Assuming that your table contained only 1 row as specified, I don't think the answer is correct. I spun up a nonce table with exactly that data and the query...
February 19, 2025 at 8:58 am
Thank you Jeff - I'd never tried that in all my years since SQL Server V7.0
November 21, 2024 at 2:43 pm
I'm doubtless being inexpressibly dim but I don't know what "It depends on whether results are in the grid or text" means.
November 21, 2024 at 8:56 am
I was reviewing a PR today and had a minor disagreement with the dev because I took exception to his failure to use braces (C#)
if (myVar == otherVar)
return true;
instead of
if...
October 18, 2024 at 2:53 pm
Personally I think the query compiler should mandate BEGIN END for this construction.
October 18, 2024 at 8:34 am
Thanks for your input everyone. When I get a moment I'll check some of these but I agree that RETURN EXECUTE is a bit odd ...
September 24, 2024 at 7:17 am
Sorry, my bad. I've updated the topic thus "there is no error message, but the updates and inserts inside the wrapped script are not executed."
September 23, 2024 at 9:44 am
Thanks to both of you. I have amended the query using OUTER APPLY (which I've only rarely used before) and that works fine.
December 13, 2023 at 8:44 am
Ah thank you Steve. Every day is a school day, particularly for me - my lesson here is to read the actual error message!
November 8, 2023 at 5:03 pm
I don't agree with this. I ran the code in my sandbox and it returned
Msg 2749, Level 16, State 3, Line 6
Identity column 'InvoiceID' must be of...
November 8, 2023 at 8:46 am
I don't use "tooling" - just SSMS and touch-typing for me. I remain unconvinced by the arguments for aliasing, but as I'm 66 and retiring in a few months I'm...
July 13, 2023 at 7:09 am
standards - and for those that do work a lot on this and use tools to help with coding, putting the alias can be automatic, and expanding the columns...
July 12, 2023 at 10:59 am
Why write this:
SELECT TOP 10
s.stateid,
s.statecode,
s.statename
FROM webapi.states AS s;
when you could save yourself some typing and write:
SELECT TOP 10
stateid,
statecode,
statename
FROM...
July 12, 2023 at 9:06 am
Viewing 15 posts - 1 through 15 (of 209 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy