June 17, 2026 at 12:00 am
Comments posted to this topic are about the item Detecting Characters
June 17, 2026 at 5:56 am
When all rows will be returned, how can 3 be a correct answer?
Best regards,
Dietmar Weickert.
June 17, 2026 at 6:12 am
It could be, if the database collation is case sensitive. But hardly 3 and 10 both at the same time, unless it's running on a quantum computer, with superposition in full force...
June 17, 2026 at 6:46 am
Does it return two result set? 🙂
June 17, 2026 at 12:18 pm
Yeah, I'm scratching my head on this one. Due to case insensitivity, I would expect all 10 rows to return, so I selected 10. I am surprised that the "correct" answer was 3 AND 10. If case insensitivity were turned off, I could see 3 rows being returned, but as specified in the question, it is using default values so case insensitivity is turned on by default.
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 17, 2026 at 4:17 pm
Default English installation is case-insensitive. You have to change the setting to be case sensitive during the install.
June 18, 2026 at 7:08 am
The answer is correct:
"3 out of 10 rows affected"
Case sensitivity strikes again. ??
June 18, 2026 at 7:16 am
Default English installation is case-insensitive. You have to change the setting to be case sensitive during the install.
Acschually, these days every single column can have its own collation and sort order. But more realistically, you can create a database with different settings than the server default.
I remeber the bad old days when changing the sort order required a re-install of SQL Server, and the names of tables, views, columns and stored procedures could wind up case sensitive.
June 18, 2026 at 4:13 pm
Sorry, both for the typo (checking the 3) and the delay (traveling yesterday).
I've awarded back points and checked only the 10, which is correct.
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply