2024年4月9日
sql server 删除重复数据
摘要： with cte as ( select GoodsId,Same_GoodsId,ROW_NUMBER() over(partition by GoodsId,Same_GoodsId order by (select 0)) as rn from Gd_FindSame_Detail_temp 阅读全文
posted @ 2024-04-09 19:23 普天2022 阅读(9) 评论(0) 推荐(0)
SqlBulkCopy批量插入数据
摘要： private void uiButton1_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add("CreateBy", typeof(System.Int64)); dt.Column 阅读全文
posted @ 2024-04-09 17:12 普天2022 阅读(22) 评论(0) 推荐(0)