Viewing 8 posts - 1 through 8 (of 8 total)
Or even here where the collations are different:
select *
from sys.objects
where name = ('sysrscols' collate French_CI_AS) collate French_CS_AS;
April 25, 2025 at 8:42 am
wow! 1% of respondants considered a cursor was the solution to a question on sequences
March 12, 2025 at 9:02 am
support for these data types was introduced in sql2005 - instead of keeping the data in the row, pointers to other pages are used to enable larger chunks of memory...
December 2, 2024 at 3:29 pm
saying an array is '0' based does not really illustrate the situation. The index is a position offset. So the first element is at the allocated address and the second...
April 5, 2024 at 9:00 am
Another QOTD where the explanation would only leave the inexperienced wondering...The correct response was to indicate the setting which would give an error but the explanation contradicts the answer...
January 12, 2024 at 9:22 am
What should we do when the answers are flawed like this? I also went for 9 hours because I assumed that was the intended correct response...
May 24, 2023 at 10:19 am
Yes, I had to try it out to prove to myself that "SELECT @sql" wasn't some underhand feature I didn't know about but of course I got the...
October 15, 2021 at 9:19 am
Thank you people - thought I'd lost the plot for a minute there. Doesn't anyone review these questions before they are published?
February 22, 2021 at 11:10 am
Viewing 8 posts - 1 through 8 (of 8 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