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