不再民工

摘要： SET QUOTED_IDENTIFIER ONSET ANSI_NULLS ONGO-- =============================================-- Author: -- Create date: -- Description: -- ===... 阅读全文

摘要： 原文地址:http://www.sqlservercentral.com/scripts/Linked+Server/64276/This Proc is written for either SQL 2000 or SQL 2005 to returna list of objects that ... 阅读全文

摘要： 需要iTextSharp.dll, 下载地址http://sourceforge.net/projects/itextsharp/ public void Test() { Watermark(@"E:\日常工作\12084347 config.pdf", @"E:\日常工作\12084347 config wm.pdf", @"E:\日常工作\wm.png"); } public bool AddWatermark(string inputPath, string outputPath, strin... 阅读全文

摘要： 主要用到3个公式Match(查找值, 区域, 是否精确查找), 找到记录的相对表格的位置索引,起始位1OFFSET(参考位置,偏移量X,偏移量Y,行数,列数),生成区域引用Vlookup(查找值, 查找区域,显示列索引,是否模糊查找) ,在数组中查找结果=VLOOKUP($L$8,OFFSET($B$4,MATCH(I9,$B$4:$B$11,0)-1,1,100,2),2,FALSE) 阅读全文

摘要： 1. 新建 WindowFormControlLibrary2. 修改 项目->右键属性->Application-> Assembly Information ->勾选 Make Assembly Com-Visible3. 修改项目->右键属性-> Build -> 勾选 Register for Com interop4. 控件cs界面, usingSystem.Runtime.InteropServices 命名空间; 类名添加 GUID属性using System;using System.Collections.Generic;using 阅读全文

摘要： 错误:Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.->"开始" -> "运行"中输入DCOMCNFG->"组件服务"->"计算机"->"我的电脑"->"DCOM配置"-> 找到"Micros 阅读全文

摘要： 1. SQL private static string GetAllStocksSql(string branch, string itemNo, string locationName, string lotControl, bool blnAvail, bool blnCount) { StringBuilder sql = new StringBuilder(); if (blnCount) { sql.Append(" SELECT Count(*) "); ... 阅读全文

摘要： SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source="E:\Project\Project Document\OJT\NameList\Namelist20134112.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[NameList$]WHERE 序号 IS NOT NULL SELECT * FROM OPENDATASOURCE('M... 阅读全文

摘要： ISO paper sizes (plus rounded inch values)FormatA series[2]B series[3]C series[4]Sizemm × mmin × inmm × mmin × inmm × mmin × in0841 × 118933.11 × 46.811000 × 141439.37 × 55.67917 × 129736.10 × 51.061594 × 84123.39 × 33.11707 × 阅读全文

摘要： SELECT * FROM sys.dm_exec_sessions WHERE host_name IS NOT NULLSP_WHO 阅读全文