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