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);
}
