摘要：When we create a part (such as list) instance, we can custom columns. But sometime we need to add a special calculated columns. The column types Lookup, Calculated and Business data would be more usef... 阅读全文

摘要：When we create a site (team site), there are limited functions as default. Click Site Actions in this team site, and select Site Setting. Click Site features under Site Administration, and then Acti... 阅读全文

摘要：We can use the webpart - Content Query Toll Part to collect most kinds of content from other team sites. There are three options in Query part, "Show items from all sites in this site collection", "... 阅读全文

摘要：To continue XPath: Selecting Nodes (VBScript) set xmlDoc=CreateObject("Microsoft.XMLDOM") xmlDoc.async="false" xmlDoc.load("books.xml") xmlDoc.selectNodes(path expression) For example: xmlDoc.selectN... 阅读全文

摘要：最近被FORECAST TOOLS设计开发搞得焦头烂额。东西很早就做出来了，可那些分布在世界各地的SALES MAN就是不肯使用。其实对于我们来说，它的使用是件很简单的事情。只要数据录入及时准确，想要什么样的报表都可以生成。但最终用户不接受，它的设计就是不成功，这个项目就不成功。 原先一直埋怨SALES MAN懒惰、无理取闹，但分析思考后觉得，问题不在他们，作为APPLICATION DEVELO... 阅读全文

摘要：在EXCEL中添加一个按钮(Command Button)，当点击时触发事件 Private Sub cmdButton_Click() Dim cnnDB As ADODB.Connection Dim cmdDB As ADODB.Command Dim rsFC As ADODB.Recordset Dim strSQL As String Dim I... 阅读全文

摘要：What is XML? XML stands for EXtensible Markup Language XML is a markup language much like HTML XML was designed to describe data XML tags are not predefined. You must d... 阅读全文

摘要：下次完善对各各参数的理解 --在不同情况下，使用参数和方法可能不一样 EXEC sp_addlinkedsrvlogin RemoteServerName,'false',null,'user','password' --连接不上时，可能有多种原因，一定能解决。目的是能同时操作多个数据库的数据 select * from RemoteServerName.RemoteDatabaseName.d... 阅读全文

摘要：HTML是轻松驾驭了，但也遇到几个很少用的标识： Tag Description NN IE DTD ... 阅读全文

摘要： 阅读全文

摘要：What are Web Services? Web services are application components Web services communicate using open protocols Web services are self-contained and self-describing Web services can be di... 阅读全文

摘要：IE: Firefox: 阅读全文

摘要：1.Whether changed the password of OS The changing of OS (login password or security policy) can reflect on SQL Server to startup. 1). Control Panel à Administrative Tools à Services à MSSQLSERVE... 阅读全文

摘要：一直没意识到它们之间的区别，只知道UNION ALL在性能上优于UNION，忽略一个很重要的区别： UNION会去掉重复的行，而UNION ALL是包括所有行。 阅读全文

摘要：1. ASCII control characters Binary Decimal Hex ... 阅读全文

摘要：有时候一个FORM里面有多个事件处理，而用户习惯于直接PRESS ENTER。 那么可以用JAVASCRITP来捕捉PRESS ENTER动作，来触发相应的事件： PRESS ENTER让光标移到下一个输入框 阅读全文

摘要：使用LIKE: DECLARE @tbItems TABLE(id INT IDENTITY(1,1),Item VARCHAR(12)) INSERT @tbItems SELECT 'A' INSERT @tbItems SELECT 'B' INSERT @tbItems SELECT 'C' INSERT @tbItems SELECT 'D' DECLARE @tbT TABLE... 阅读全文

摘要：--under the database we will search SELECT NAME --NAME, the name of table FROM SYSOBJECTS WHERE TYPE='u' --u, tables; p, stored procedures; v, views AND ID IN( SELECT ID ... 阅读全文

摘要：When we develop a function to let client download the files not directly open in the internet explorer, there are two ways. One is coding an intergrade file under reading and writing binary file, suc... 阅读全文

摘要：在使用MS Reporter做报表时，有些功能不能实现，可以用VB自定义一个函数来处理。比如下面的： 打开一个报表文件.RDLC时，在非操作区点右键，选择属性，再选择CODE选项卡，输入下列代码 Public Function GetPersent()Function GetPersent(ByVal vASP As Decimal, ByVal vMCOS As Decimal, ByVal v... 阅读全文

摘要：String.Format("{0}", "formatting string"}; //Uses the "en-US" culture. enum Color {Yellow = 1, Blue, Green}; static DateTime thisDate = DateTime.Now; //Format the strings s=String.Format( ... 阅读全文

摘要：理解了数据库中的指针，但让凭空写出这些代码好像还有些困难，这可能是熟练的问题吧。 DECLARE @Customer VARCHAR(40),@Project VARCHAR(40) DECLARE @NUM INT,@NUM1 INT,@iID INT DECLARE CUR_Backlog CURSOR FOR SELECT Customer,Project FROM BACKLOG ... 阅读全文

摘要：--Get repeat records under UNIQUE SELECT Period, CustomerCode, ProjectCode FROM ForeCast_Backlog GROUP BY Period, CustomerCode, ProjectCode HAVING (COUNT(*) > 1) --Update the records using ... 阅读全文

摘要：这是我第一次学着写存储过程，虽然完成了目标，但不知道是否有更好的写法 CREATE PROCEDURE [dbo].[spForecast_ForeCast_YearlyReport] @sFC_Period VARCHAR(6) AS SET NOCOUNT ON; DECLARE @SQL NVARCHAR(4000) DECLARE @SQL1 NVARCHAR(200... 阅读全文