Viewing 15 posts - 16 through 30 (of 200 total)
Thank you Jeff and Scott for your excellent posts. Every day is a school day, even for a soon-to-be-66 year-old programmer who, it appears, only dabbles in SQL (my main...
January 20, 2023 at 8:22 pm
Thanks Thom. I disagree about aliasing because I don't see the point except when a table is JOINed more than once in the same statement. The reason I raised the...
January 20, 2023 at 4:33 pm
The formatting of the answers makes them look more or less identical, so it was a guess as to which of the seemingly identical options was correct.
January 13, 2023 at 8:20 am
I worked at a software house where the rules were quite strict on triggers - they were not to be used. So when we were getting glitches and couldn't work...
December 14, 2022 at 6:40 pm
Can anyone imagine a scenario where such a catastrophic design decision was actually necessary?
December 14, 2022 at 8:13 am
It only checks on column. If table does not exist statement will fail. So in fact old-style if checking on information_schema.columns would be more bulletproof as you can search...
October 3, 2022 at 8:55 am
Maybe I've misunderstood but wouldn't it be prudent to check that the table exists before attempting to alter a column?
September 30, 2022 at 8:34 am
The SUM would be of StaffLeaveRequest.TimeRequested where the status was either APPROVED or PENDING. I omitted some of the nuance for clarity.
August 24, 2022 at 12:29 pm
The correct answer should be "Create Certificate". There is no LOAD CERTIFICATE Command.
I came here to say that.
July 20, 2022 at 8:49 am
Why is it "much easier"?
SELECT @@VERSION
SELECT * FROM sys.dm_os_windows_info
Intellisense supplies @@Version and it's 20 fewer characters to get wrong.
June 13, 2022 at 8:40 am
Cool, sorry - I misread your comment ;¬}
February 2, 2022 at 2:39 pm
The question was "I want to get some data in a SELECT statement, but I don't have a table or view that matches my needs. What can I put into...
February 2, 2022 at 2:10 pm
I'm afraid I take issue with the question. I answered CTE because a CTE is neither a table nor a view and
SELECT * FROM MyCte
is perfectly valid.
February 2, 2022 at 9:30 am
"Single database, elastic pool, and Hyperscale" is listed as the correct answer, but I believe it should have been just "single database and elastic pool?
What Terje said.
January 31, 2022 at 9:14 am
I don't understand the answer. The linked article states:
Permissions
To execute DROP AGGREGATE, at a minimum, a user must have ALTER permission on the schema to which the user-defined aggregate belongs,...
November 8, 2021 at 10:12 am
Viewing 15 posts - 16 through 30 (of 200 total)