C# (CSharp) SqlTopLimitNode Examples

Example #1

File: StringifyVisitor.cs Project: Whiteknight/SqlParser

 public ISqlNode VisitTopLimit(SqlTopLimitNode n)
 {
     Append("TOP (");
     Visit(n.Value);
     Append(")");
     if (n.Percent)
     {
         Append(" PERCENT");
     }
     if (n.WithTies)
     {
         Append(" WITH TIES");
     }
     return(n);
 }

Example #2

File: SqlNodeValidateVisitor.cs Project: Whiteknight/SqlParser

 public override ISqlNode VisitTopLimit(SqlTopLimitNode n)
 {
     return(base.VisitTopLimit(n));
 }

Example #3

File: SqlNodeVisitor.cs Project: Whiteknight/SqlParser

        public virtual ISqlNode VisitTopLimit(SqlTopLimitNode n)
        {
            var value = Visit(n.Value);

            return(n.Update(value, n.Percent, n.WithTies));
        }

Example #4

 public ISqlNode VisitTopLimit(SqlTopLimitNode n)
 {
     Append("LIMIT ", n.Value);
     return(n);
 }