- 博客(6)
- 收藏
- 关注
原创 SQL - 拷贝列数据
--Copy data from column to column UPDATE [dbo].[CZHJOriginalData] set [OEMIdentified] = ##table1.[VehiclePartOemID] from [CZHJOriginalData] COD join ##table1 on ##table1.ID = COD.ID where ##ta
2015-03-13 17:58:57 483
转载 SQL - 脚本Tips
DBCC CHECKIDENT('[table_name]', RESEED, [new_reseed_value]) -- for example DBCC CHECKIDENT('product', RESEED, 0)
2015-03-12 13:24:04 448
原创 c# - 拆分大文件
Split big file to separate files. public static void SplitFile(string filename) { char[] chunk = new char[1024 * 1024 * 50]; int count = 1; using (StreamR
2015-03-05 09:51:08 1549
转载 SQL - 删除 重复数据
Assuming no nulls, you GROUP BY the unique columns, and SELECT the MIN (or MAX) RowId as the row to keep. Then, just delete everything that didn't have a row id:DELETE MyTable FROM MyTable LEFT OUTER
2015-03-04 17:51:19 428
转载 LOG4Net Configuration.
http://www.codeproject.com/Articles/140911/log-net-Tutorial
2015-03-04 10:49:21 339
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人