public static string GetTableColumns(string TableName)
{
var ProCols = new List <string>();
var Schema10 = H3DBHelper.GetTableSchema(TableName, "V10");
var Schema9 = H3DBHelper.GetTableSchema(TableName, "V9");
foreach (var filed in Schema10)
{
var tt = Schema9.Where(a => a.Name == filed.Name);
if (Schema9.Contains(filed))
{
ProCols.Add("[" + filed.Name + "]");
}
}
return(string.Join(",\n", ProCols.ToArray()));
}
