internal string SelectIntoStagingTable(IEnumerable<SqlColumn> columns)
{
return Store(SqlBuilderHelper.SelectIntoTableQuery(FullyQualifiedTableName, BulkStagingTable, columns));
}
/// <summary>
/// Creates an SQL command to clone specific columns from a table into a temporary table.
/// </summary>
/// <param name="sourceTable">The table to clone.</param>
/// <param name="tempTable">The temporary to create.</param>
/// <param name="columns">The columns to copy.</param>
/// <returns>A command to create a temporary table with specific columns.</returns>
public string SelectIntoTempTable(string sourceTable, string tempTable, IEnumerable <SqlColumn> columns)
{
return(string.Format(CreateTempTable, tempTable) + SqlBuilderHelper.SelectIntoTableQuery(sourceTable, tempTable, columns));
}