摘要： 在excel中,将长*宽*高这样的格式列,拆分成3列=MID(D6,1,FIND("*",D6)-1)长=MID($D6,FIND("*",D6)+1,FIND("*",D6,FIND("*",D6)+1)-FIND("*",D6)-1)宽=MID($D6,FIND("*",D6,FIND("*",D6)+1)+1,LEN(D6))高其中D6为你原来长*宽*高这样的格式列 毛净重Kg 19/16 26/23 将毛净重拆开=MID(F4,1,FIND(&qu 阅读全文

摘要： --select*fromProductwhereProCode='DWIHEE00108'--declare@resultint--execxp_fileexist'C:\test\testsdfs.txt',@resultoutput--select@resultdeclare@resultint,@proiduniqueidentifier,@proimgurl1nvarchar(100)declaremyCursorcursorforselectproid,proimgurl1fromproductopenmyCursorfetchmyCursorint 阅读全文

摘要： 遇到一个客户，希望在Reporting Services的报表中引用FTP站点上的图片，但是访问这个FTP站点需要用户名和密码！好不容易把这个问题解决，以下是我的解决步骤。1. 添加一段自定义报表以获取图片: Public Shared Function GetImageFromFTPServer(ByVal imageURL As String) As Byte() Dim request As System.Net.WebClient = New System.Net.WebClient() request.Credentials = New System.Net.NetworkCrede 阅读全文

摘要： varORG_NAME="test";varSERVICE_PATH="/mscrmservices/2007/CrmService.asmx"varauthenticationHeader=GenerateAuthenticationHeader();functiongetCurrentUserName(){varxml=""+"<?xmlversion=\"1.0\"encoding=\"utf-8\"?>"+"<soap:Envelopexm 阅读全文

摘要： alert(UserHasRole("SystemAdministrator"));functionUserHasRole(roleName){//getCurrentUserRoles,oXmlisanobjectvaroXml=GetCurrentUserRoles();if(oXml!=null){//selectthenodetextvarroles=oXml.selectNodes("//BusinessEntity/q1:name");if(roles!=null){for(i=0;i<roles.length;i++){if(role 阅读全文

摘要： varscript=document.createElement('script');script.setAttribute('runat','server');script.setAttribute('language','javascript');script.text="functionUserHasRole(roleName){varoXml=GetCurrentUserRoles();if(oXml!=null){varroles=oXml.selectNodes(\'//Busines 阅读全文

摘要： varxml=""+"<?xmlversion=\"1.0\"encoding=\"utf-8\"?>"+"<soap:Envelopexmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\"xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"xmlns:xsd=\"http://www.w3.org/2001/XMLSche 阅读全文

摘要： varORG_NAME="xteam";functionretrieve(entityName,entityId,attributeName){varxml=""+"<?xmlversion=\"1.0\"encoding=\"utf-8\"?>"+"<soap:Envelopexmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\"xmlns:xsi=\"http://www.w3 阅读全文

摘要： js代码折叠插件 阅读全文

摘要： 代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--declare@iint=1declare@tmpTabletable(Iduniqueidentifierprimarykey)deletedbo.OpportunityExtensionBasedeletedbo.OpportunityProductExtensionBasedeletedbo.OpportunityProductBasedeletedbo.OpportunityCloseBa 阅读全文