Skip to content

sqlsunday.com

  • About
  • Structured Concepts
    • Master data tool
    • OAuth wizard
    • Send passwords
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Installing SQL Server 2022
    • Conference organizer tools
    • Conference organizer checklist

Tag: string parsing

STRING_SPLIT(), but for quoted names

Can you apply gaps and islands logic on a string? Sure you can.

Continue reading STRING_SPLIT(), but for quoted names
Published 2022-04-22
Categorized as Intermediate, SQL Server concepts, T-SQL, Tips Tagged quoted, string parsing, string_agg, string_split, windowed function

Fun with random names

Just for laughs, we’re going to take a look at a slightly-too-complex yet elegant solution to a seemingly simple task: creating a list of 100 fictional company names for a demo database.

Continue reading Fun with random names
Published 2017-09-18
Categorized as Intermediate, T-SQL Tagged apply, common table expression, cte, demo, name, newid, outer apply, random, string parsing, sys.messages
sqlsunday.com
Proudly powered by WordPress.