SQL-Challenges - Improve your SQL Server Skills
  • Home
  • SQL Challenges
    • Level 200
    • Level 300
    • Level 400
  • Contact us
  • FAQ
Select Page
SQL Challenge #3 – Case Sensitive Searches

SQL Challenge #3 – Case Sensitive Searches

by Uwe Ricken | Feb 2, 2025 | Level 200, SQL Challenges

Problem Description / Requirement The software manufacturer’s database uses the [SQL_Latin1_General_CP1_CI_AS] collation for the application. The development team wrote a custom function that can be used to find customers based on an address search. The...
SQL Challenge #1 – When the marketing department calls

SQL Challenge #1 – When the marketing department calls

by Uwe Ricken | Jan 20, 2025 | Level 200, SQL Challenges

Problem Description / Requirement The marketing department of db Berater GmbH is planning a private event for its 10 TOP customers. The marketing department provides the following guidelines for selecting customers: Only customers with at least 3 orders in the last...

SQL Challenges

  • SQL Challenge #7 – Dynamically added attributes 2025-04-07
  • SQL Challenge #6 – Locking locks your SQL Server 2025-03-03
  • SQL Challenge #5 – When Constraints not work 2025-02-17
  • SQL Challenge #4 – Nightmares with User Defined Functions 2025-02-09
  • SQL Challenge #3 – Case Sensitive Searches 2025-02-02
  • Imprint
  • Data Protection
  • RSS

db Berater GmbH | | Büchenweg 4 | 64390 Erzhausen | Phone: +49 (0) 6150 5082955 | E-Mail: info@db-berater.de |    Umsetzung