select distinct top 10 t.Phone,w.Phone,w.CreateTime
from ( select Phone from test) t
Outer Apply ( select top 1 Phone,CreateTime from test w where t.Phone=w.Phone ORDER BY CreateTime DESC ) w
ORDER BY CreateTime DESC
public static void DataTableToSQLServer2(DataTable dt, string connectString)
{
string connectionString = connectString;
using (SqlConnection destinationConnection = new SqlConnection(connectionString))
{
destinationConnection.Open();
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(destinationConnection))
{
try
{
bulkCopy.DestinationTableName = "PMTC_IM_MII_MachineStatus";//要插入的表的表名
bulkCopy.BatchSize = dt.Rows.Count;
bulkCopy.ColumnMappings.Add("MachineID", "MachineID");//映射字段名 DataTable列名 ,数据库 对应的列名
bulkCopy.ColumnMappings.Add("MachineDescription", "MachineDescription");
bulkCopy.ColumnMappings.Add("MachineStatus", "MachineStatus");
bulkCopy.ColumnMappings.Add("Planned", "Planned");
bulkCopy.ColumnMappings.Add("DowntimeReason", "DowntimeReason");
bulkCopy.ColumnMappings.Add("[Duration(min)]", "[Duration(min)]");
bulkCopy.WriteToServer(dt);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
}
}
}