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: syntax

Parsing parenthesis expressions

Today’s post illustrates a pretty cool application of SQL Server’s built-in XML and XQuery support, used to parse parenthesis-delimited expressions. You may want to get your reading glasses on for this one..

Continue reading Parsing parenthesis expressions
Published 2014-03-09
Categorized as Advanced, Scripts, T-SQL Tagged balanced, bracket, expression, formula, parenthesis, parsing, recursion, syntax, xml

Processing order of a T-SQL statement

There are three different perspectives when you look at a T-SQL statement; the way it’s written, the way it’s evaluated, and the way it’s executed. They’re all important to understand, for different reasons.

Continue reading Processing order of a T-SQL statement
Published 2013-03-31
Categorized as Intermediate, SQL Server concepts Tagged actual, evaluating, execution order, logical, parsing, processing order, query plan, query processing, syntax
sqlsunday.com
Proudly powered by WordPress.