- 博客(6)
- 收藏
- 关注
RSS订阅原创 SQL - 拷贝列数据
--Copy data from column to columnUPDATE [dbo].[CZHJOriginalData] set [OEMIdentified] = ##table1.[VehiclePartOemID]from [CZHJOriginalData] CODjoin ##table1 on ##table1.ID = COD.IDwhere ##ta
2015-03-13 17:58:57
483
转载 SQL - 脚本Tips
DBCC CHECKIDENT('[table_name]', RESEED, [new_reseed_value])-- for exampleDBCC 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 MyTableLEFT OUTER
2015-03-04 17:51:19
427
转载 LOG4Net Configuration.
http://www.codeproject.com/Articles/140911/log-net-Tutorial
2015-03-04 10:49:21
339
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人