protected virtual string CreateStagingTableSql()
=> $@"SELECT TOP 0 { string.Join(",", PropertiesToBulkLoad.Select(i => $"T.{i.SqlServer().ColumnName}")) }, 0 as {TempColumnNumOrderName}
INTO {SqlStagingTableName} FROM {SqlTargetTable} AS T
LEFT JOIN {SqlTargetTable} AS Source ON 1 = 0;";
protected virtual string CreateStagingTableSql()
=> $@"SELECT TOP 0 { string.Join(",", PropertiesToBulkLoad.Select(i => $"T.{i.GetColumnName(base.StoreObject)}")) }
INTO {SqlStagingTableName} FROM {SqlTargetTable} AS T
LEFT JOIN {SqlTargetTable} AS Source ON 1 = 0;";
protected virtual string CreateStagingTableSql()
=> $@"SELECT TOP 0 { string.Join(",", PropertiesToBulkLoad.Select(i => $"T.[{i.GetColumnName(base.StoreObject)}]")) }, 0 as [{TempColumnNumOrderName}]
INTO {SqlStagingTableName} FROM {SqlTargetTable} AS T
LEFT JOIN {SqlTargetTable} AS Source ON 1 = 0 option(recompile);";