Sql Server 解析流程
2022-10-01 15:52:22 0 举报
t-sql 常用语法解析流程
作者其他创作
大纲/内容
IntegerLiteralExpression
SqlTableRefExpression
OnePartObjectIdentifier
SqlSelectStatement
SqlSimpleGroupByItem
SqlComparisonBooleanExpression(a=1)- ComparisonOperator
SqlInBooleanExpression(a like b)
SqlColumnAssignment
SqlWhereClause
Select
SqlQuerySpecification
TwoPartObjectIdentifier(table.id)
SqlGroupByClause
SqlQualifiedJoinTableExpression(含Join)
SqlAggregateFunctionCallExpression(max(field))- FunctionName
SqlDerivedTableExpression(子查询)
SqlSelectScalarExpression(查询单元表达式)
SqlSelectScalarExpression(回溯至此)
SqlUpdateSpecification
SqlColumnRefExpression(直接显示字段 || userid as id)
SqlColumnRefExpression
SqlFromClause(from ...)
SqlIdentifier(table | id)
SqlRowConstructorExpression
回溯
SqlColumnOrPropertyRefExpression(带前缀的字段:table.id)
SqlComparisonBooleanExpression
SqlIdentifier(user)
SqlSetClause
IntegerLiteralExpression(long 数据)
SqlTableConstructorInsertSource
SqlInsertSpecification
SqlBetweenBooleanExpression(a like b)
SqlSearchedWhenClause(when a=1 then 1)最后一个是Else
SqlBinaryBooleanExpression(join condition)
OnePartObjectIdentifier(user)
StringLiteralExpression(string 数据)
SqlIdentifier(tt)
基础数据
SqlIdentifier(id)
SqlScalarSubQueryExpression(子查询)
SqlOrderByClause
SqlWhereClause(where ...)
Update
Insert
SqlBatch
SqlSearchedCaseExpression(case when 表达式)
SqlDeleteSpecification
SqlInsertStatement
SqlHavingClause
SqlTableRefExpression(回溯)
SqlSelectSpecification
SqlComparisonBooleanExpression(a=b)
StringLiteralExpression
Delete
SqlTopSpecification(top 100)
SqlIdentifier
SqlSelectStarExpression(*)
OnePartObjectIdentifier(userid)
SqlTableRefExpression(user tt)多表就是多个
NumericLiteralExpression(float 数据)
SqlDeleteStatement
SqlInBooleanExpressionCollectionValue
SqlUpdateStatement
SqlOrderByItem
SqlLikeBooleanExpression(a like b)
SqlConditionClause(join condition 带 on)
收藏
0 条评论
下一页