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("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.WriteLine("BEGIN"); Items.WriteToStream(stream); stream.WriteLine(); stream.Write("END"); }
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("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) { Name.WriteToStream(stream); stream.Write(" "); DataType.WriteToStream(stream); Size?.WriteToStream(stream); }
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) { stream.Write("OPTION"); stream.Write("("); Maxdop.WriteToStream(stream); stream.Write(")"); }
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("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(":SETVAR "); Name.WriteToStream(stream); stream.Write(" "); Value.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write("MERGE"); if (!string.IsNullOrEmpty(IntoToken)) { stream.Write($" {IntoToken}"); } stream.Write(" "); TargetTable.WriteToStream(stream); if (WithOptions != null && WithOptions.Count > 0) { stream.Write(" WITH("); WithOptions.WriteToStreamWithComma(stream); stream.Write(")"); } if (TargetTableAliasName != null) { stream.Write(" AS "); TargetTableAliasName.WriteToStream(stream); } stream.WriteLine(); stream.Write("USING "); TableSource.WriteToStream(stream); if (TableSourceAliasName != null) { stream.Write(" AS "); TableSourceAliasName.WriteToStream(stream); } if (SourceColumnList != null && SourceColumnList.Count > 0) { stream.Write("("); SourceColumnList.WriteToStreamWithComma(stream); stream.Write(")"); } stream.Write(" ON "); OnMergeSearchCondition.WriteToStream(stream); if (WhenList != null && WhenList.Count > 0) { stream.WriteLine(); WhenList.WriteToStream(stream); } if (OutputList != null && OutputList.Count > 0) { stream.WriteLine(); stream.Write("OUTPUT "); OutputList.WriteToStreamWithComma(stream); } stream.Write(" ;"); }
public override void WriteToStream(IndentStream stream) { stream.Write("SET "); Name.WriteToStream(stream); stream.Write($" {Oper} "); Value.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { if (!string.IsNullOrEmpty(JoinType)) { stream.Write($"{JoinType.ToUpper()} "); } if (!string.IsNullOrEmpty(OuterType)) { stream.Write($"{OuterType.ToUpper()} "); } stream.Write("JOIN "); SecondTable.WriteToStream(stream); if (AliasName != null) { stream.Write(" "); AliasName.WriteToStream(stream); } if (WithOptions != null && WithOptions.Count > 0) { stream.Write(" WITH("); WithOptions.ToUpper().WriteToStreamWithComma(stream); stream.Write(")"); } if (JoinOnExpr != null) { stream.Write(" ON "); JoinOnExpr.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("DECLARE "); Name.WriteToStream(stream); stream.Write(" "); DataType.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { DataType.WriteToStream(stream); // if (IsIdentity) // { // stream.Write(" IDENTITY"); // } // // if (IsReadOnly) // { // stream.Write(" READONLY"); // } // // if (SizeExpr != null) // { // SizeExpr.WriteToStream(stream); // } if (ExtraList != null && ExtraList.Count > 0) { stream.Write(" "); ExtraList.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("CREATE SYNONYM "); Name.WriteToStream(stream); stream.Write(" FOR "); ObjectId.WriteToStream(stream); }
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) { Left.WriteToStream(stream); stream.Write(" NOT IN ("); Right.WriteToStream(stream); stream.Write(")"); }
public override void WriteToStream(IndentStream stream) { stream.Write("INSERT "); if (!string.IsNullOrEmpty(IntoStr)) { stream.Write($"{IntoStr.ToUpper()} "); } TableName.WriteToStream(stream); if (Columns != null && Columns.Count > 0) { stream.Write("("); Columns.WriteToStreamWithComma(stream); stream.Write(")"); } if (WithExpr != null) { stream.Write(" "); WithExpr.WriteToStream(stream); } stream.Write(" VALUES"); stream.WriteLine(); foreach (var values in ValuesList.Select((val, idx) => new { val, idx })) { if (values.idx != 0) { stream.WriteLine(","); } stream.Write("("); values.val.WriteToStream(stream); stream.Write(")"); } }
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) { Left.WriteToStream(stream); stream.Write(" NOT BETWEEN "); Start.WriteToStream(stream); stream.Write(" AND "); End.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { stream.Write("BREAK"); if (IsSemicolon) { stream.Write(" ;"); } }
public override void WriteToStream(IndentStream stream) { Name.WriteToStream(stream); if (!string.IsNullOrEmpty(AscOrDesc)) { stream.Write($" {AscOrDesc}"); } }
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) { LeftExpr.WriteToStream(stream); stream.Write(" BETWEEN "); StartExpr.WriteToStream(stream); stream.Write(" AND "); EndExpr.WriteToStream(stream); }
public override void WriteToStream(IndentStream stream) { Name.WriteToStream(stream); if (!string.IsNullOrEmpty(SortToken)) { stream.Write($" {SortToken.ToUpper()}"); } }
public override void WriteToStream(IndentStream stream) { stream.Write("WHEN "); ConditionExpr.WriteToStream(stream); stream.WriteLine(); stream.Write("THEN "); ThenExpr.WriteToStream(stream); }