Exemplo n.º 1
0
        public InsertClause InsertTopPercentInto(Expression percent, Table table, params Column[] columns)
        {
            var statement = new InsertStatement(this);
            var clause    = new InsertTopPercentIntoTable(statement, percent, table, columns);

            statement.FirstFragment = clause;
            return(clause);
        }
Exemplo n.º 2
0
        public void InsertTopPercentIntoTable(SqlFragment insertTop, InsertTopPercentIntoTable insertTopPercentIntoTable)
        {
            this.Script.Append("INSERT TOP (");
            this.Script.AppendFragment(insertTopPercentIntoTable.Percent, insertTopPercentIntoTable, this);
            this.Script.Append(") PERCENT INTO");
            this.Script.AppendFragment(insertTopPercentIntoTable.Table, insertTopPercentIntoTable, this);

            if (insertTopPercentIntoTable.ColumnList.Any())
            {
                this.Script.Append("(");
                ExpressionFormatter.FormatColumnList(insertTopPercentIntoTable.ColumnList, insertTopPercentIntoTable, this.Script, this);
                this.Script.Append(")");
            }
        }