Viewing 15 posts - 1 through 15 (of 29 total)
I'm afraid the given answer is not correct. using the SalesDate as part of the SELECT will deliver 10 unique rows. Removing the date then does indeed provide 8...
February 26, 2025 at 5:55 am
I'm afraid the given answer is not correct. using the SalesDate as part of the SELECT will deliver 10 unique rows. Removing the date then does indeed provide 8 unique...
February 26, 2025 at 5:49 am
Agree with Jeff. from BOL:
Requires membership in the sysadmin fixed server role or membership in the public fixed database role in the master database with EXECUTE permission...
July 17, 2020 at 1:47 pm
I'm afraid none of the answers are correct.
as it stands, it would only work if there was a database with the date as part of the name, which would write...
March 16, 2020 at 5:01 am
There are actually 2 different, but related, errors:
The date is included in the literal;
the time contains a letter "p" that is not recognised;
therefore, answers 2 and 3 are equally valid
January 9, 2020 at 6:44 am
The 2nd and 4th answers appear to be the same?
November 27, 2019 at 9:06 am
Methinks there is a minor fail.
no options correct?
Good question, execution not so much
May 2, 2019 at 5:07 am
Nice question, thanks Kendra
Had to field something similar fairly recently.
A developer wrote all his tables, views & procs im model, but could not understand why new databases contained...
March 4, 2019 at 11:35 pm
Brilliant..
Nice one to start the week on, thanks Evgeny
July 22, 2018 at 11:02 pm
and here i thought - am i losing my marbles?
the space after the coma in the delimiter will surely cause an error...
glad i'm not the only one who...
July 8, 2018 at 11:25 pm
This is great, exactly what I was looking for....
July 3, 2018 at 1:48 am
Trying to explain this to a junior dba who believes he knows everything about everything.
talk about an uphill battle - he believes that because the server only hosts one...
June 20, 2018 at 2:55 am
Viewing 15 posts - 1 through 15 (of 29 total)