摘要： 取出分组的头一条记录SELECT * FROM (Select OrderId,Pro_Id,TotalPro_Count,RowCnt = ROW_NUMBER() OVER(PARTITION BY OrderId ORDER BY TotalPro_Count desc) From(SELECT OrderId, Pro_Id, Sum(Pro_Count) as TotalPro_Count FROM Order_Pro_ListWHERE OrderId IN(2011081013367,2011072613014,2011082315204,2011082315779)GROUP. 阅读全文

摘要： VS2008快捷键大全调试快捷键F6: 生成解决方案Ctrl+F6: 生成当前项目F7: 查看代码Shift+F7: 查看窗体设计器F5: 启动调试Ctrl+F5: 开始执行(不调试)Shift+F5: 停止调试Ctrl+Shift+F5: 重启调试F9: 切换断点Ctrl+F9: 启用/停止断点Ctrl+Shift+F9: 删除全部断点F10: 逐过程Ctrl+F10: 运行到光标处F11: 逐语句编辑快捷键Shift+Alt+Enter: 切换全屏编辑Ctrl+B,T / Ctrl+K,K: 切换书签开关Ctrl+B,N / Ctrl+K,N: 移动到下一书签Ctrl+B,P: 移动到上一 阅读全文

摘要： string path = @"D:\1.sql"; StreamReader sr = File.OpenText(path); DataTable dt = new DataTable(); dt.Columns.Add("UserName",typeof(string)); dt.Columns.Add("UserPwd", typeof(string)); dt.Columns.Add("Email", typeof(string)); int i = 0; int j = 0; while (!sr.En 阅读全文