public override void WriteToStream(IndentStream stream) { stream.Write("GRANT "); PermissionList.Select(x => x.ToUpper()).WriteToStreamWithComma(stream); if (OnObjectId != null) { stream.WriteLine(); stream.Write("ON "); OnObjectId.WriteToStream(stream); } stream.Write(" TO "); TargetList.WriteToStreamWithComma(stream); if (AsDbo != null) { stream.Write(" AS "); AsDbo.WriteToStream(stream); } if (IsSemicolon) { stream.Write(" ;"); } }
public override void WriteToStream(IndentStream stream) { stream.Write("SELECT "); Columns.WriteToStream(stream); stream.Write(" FROM "); From.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write("CREATE ROLE "); RoleName.WriteToStream(stream); stream.Write(" AUTHORIZATION "); SchemaName.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write("DECLARE "); Name.WriteToStream(stream); stream.Write(" "); DataType.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write("CREATE LOGIN "); LoginName.WriteToStream(stream); stream.Write(" WITH PASSWORD = "); Password.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write("INSERT INTO "); Table.WriteToStream(stream); if (ColumnsList != null && ColumnsList.Count > 0) { stream.Write("("); ColumnsList.WriteToStreamWithComma(stream); stream.Write(")"); } if (WithExpr != null) { stream.Write(" "); WithExpr.WriteToStream(stream); } if (OutputList != null && OutputList.Count > 0) { stream.WriteLine(); stream.Write("OUTPUT "); OutputList.WriteToStreamWithComma(stream); } if (OutputIntoExpr != null) { stream.WriteLine(); OutputIntoExpr.WriteToStream(stream); } stream.WriteLine(); SelectFromExpr.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write("CREATE SYNONYM "); Name.WriteToStream(stream); stream.Write(" FOR "); ObjectId.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { Name.WriteToStream(stream); stream.Write("("); Column.WriteToStream(stream); stream.Write(")"); }
public override void WriteToStream(IndentStream stream) { stream.Write("CREATE TYPE "); Name.WriteToStream(stream); stream.Write(" AS "); TypeExpr.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write($"DROP {TargetId}"); stream.Write(" "); ObjectId.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write("CASE"); if (InputExpr != null) { stream.Write(" "); InputExpr.WriteToStream(stream); } foreach (var whenExpr in WhenList) { stream.WriteLine(); whenExpr.WriteToStream(stream); } if (ElseExpr != null) { stream.WriteLine(); stream.Write("ELSE "); ElseExpr.WriteToStream(stream); } stream.WriteLine(); stream.Write("END"); }
public override void WriteToStream(IndentStream stream) { stream.Write("SET "); Name.WriteToStream(stream); stream.Write($" {Oper} "); Value.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write(":SETVAR "); Name.WriteToStream(stream); stream.Write(" "); Value.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write("OPTION"); stream.Write("("); Maxdop.WriteToStream(stream); stream.Write(")"); }
public override void WriteToStream(IndentStream stream) { Left.WriteToStream(stream); stream.Write(" NOT IN ("); Right.WriteToStream(stream); stream.Write(")"); }
public override void WriteToStream(IndentStream stream) { stream.Write("CONSTRAINT "); ConstraintName.WriteToStream(stream); stream.Write($" "); KeyType.WriteToStream(stream); if (ClusterExpr != null) { stream.Write(" "); ClusterExpr.WriteToStream(stream); } if (WithExpr != null) { stream.Write(" "); WithExpr.WriteToStream(stream); } if (OnPrimary != null) { stream.Write(" "); OnPrimary.WriteToStream(stream); } }
public override void WriteToStream(IndentStream stream) { LeftExpr.WriteToStream(stream); stream.Write(" BETWEEN "); StartExpr.WriteToStream(stream); stream.Write(" AND "); EndExpr.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write("WHEN "); ConditionExpr.WriteToStream(stream); stream.WriteLine(); stream.Write("THEN "); ThenExpr.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { Left.WriteToStream(stream); stream.Write(" NOT BETWEEN "); Start.WriteToStream(stream); stream.Write(" AND "); End.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write("SET "); var optionsStr = string.Join(", ", Options.Select(x => x.ToUpper())); stream.Write(optionsStr); stream.Write($" {Toggle.ToUpper()}"); }
public override void WriteToStream(IndentStream stream) { stream.Write("BREAK"); if (IsSemicolon) { stream.Write(" ;"); } }
public override void WriteToStream(IndentStream stream) { stream.Write($"{Option.ToString().ToUpper()}"); if (RightExpr != null) { stream.Write(" "); RightExpr.WriteToStream(stream); } }
public override void WriteToStream(IndentStream stream) { stream.Write("TOP "); NumberExpr.WriteToStream(stream); if (IsPercent) { stream.Write(" PERCENT"); } }
public override void WriteToStream(IndentStream stream) { stream.Write("UNION "); if (!string.IsNullOrEmpty(UnionMethod)) { stream.Write($"{UnionMethod} "); } RightExpr.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write("CREATE INDEX "); IndexName.WriteToStream(stream); stream.Write(" ON "); TableName.WriteToStream(stream); stream.Write("("); OnColumns.WriteToStreamWithComma(stream); stream.Write(")"); }
public override void WriteToStream(IndentStream stream) { stream.Write("("); stream.Write(Size); if (Scale != null) { stream.Write($",{Scale}"); } stream.Write(")"); }
public override void WriteToStream(IndentStream stream) { stream.Write($"{ClusterType.ToUpper()}"); if (ColumnList != null && ColumnList.Count > 0) { stream.Write("("); ColumnList.WriteToStreamWithComma(stream); stream.Write(")"); } }
public override void WriteToStream(IndentStream stream) { stream.Write("DELETE"); if (TopExpr != null) { stream.Write(" "); TopExpr.WriteToStream(stream); } stream.Write(" FROM "); Table.WriteToStream(stream); if (WithOptions != null && WithOptions.Count > 0) { stream.Write(" WITH("); WithOptions.WriteToStreamWithComma(stream); stream.Write(")"); } if (OutputList != null && OutputList.Count > 0) { stream.WriteLine(); stream.Write("OUTPUT "); OutputList.WriteToStreamWithComma(stream); } if (IntoTableExpr != null) { stream.WriteLine(); IntoTableExpr.WriteToStream(stream); } if (OutputList1 != null && OutputList1.Count > 0) { stream.WriteLine(); stream.Write("OUTPUT "); OutputList.WriteToStreamWithComma(stream); } if (FromSourceList != null && FromSourceList.Count > 0) { stream.WriteLine(); stream.Write("FROM "); FromSourceList.WriteToStreamWithComma(stream); } if (WhereExpr != null) { stream.WriteLine(); stream.Write("WHERE "); WhereExpr.WriteToStream(stream); } if (OptionExpr != null) { stream.WriteLine(); OptionExpr.WriteToStream(stream); } }
public override void WriteToStream(IndentStream stream) { Variable.WriteToStream(stream); stream.Write("."); NodesExpr.WriteToStream(stream); stream.Write(" AS "); AliasName.WriteToStream(stream); stream.Write("("); ColumnName.WriteToStream(stream); stream.Write(")"); }
public override void WriteToStream(IndentStream stream) { stream.Write("DROP ROLE"); if (IfExists) { stream.Write(" IF EXISTS"); } stream.Write(" "); RoleName.WriteToStream(stream); }