摘要：You AskedAre analytical functions replacement for aggregate functions? Some of the developers here are hurrying in replacing the group by aggregate functions with analytical functions just because the... 阅读全文
分析函数计算起始,结束日期.
2010-07-22 17:03 by Tracy., 298 阅读, 0 推荐, 收藏, 编辑
摘要：You AskedI have a table from a 3rd party application that is used to trackan order through the various manufacturing operations. A subset ofthe information looks like this: ORDER OPN STATION CLOSE_DAT... 阅读全文
Returning Ranked Results with Microsoft SQL Server 2005
2010-07-22 16:41 by Tracy., 387 阅读, 0 推荐, 收藏, 编辑
摘要：IntroductionIn early November 2005, Microsoft launched three new product lines: Visual Studio 2005, SQL Server 2005, and the .NET Framework version 2.0 (which includes ASP.NET version 2.0). SQL Server... 阅读全文
林宥嘉《说谎》的歌词
2010-07-22 16:05 by Tracy., 1782 阅读, 0 推荐, 收藏, 编辑
摘要：曲：李双飞 词：施人诚 是有过几个不错对象 说起来并不寂寞孤单 可能我浪荡 让人家不安 才会结果都阵亡 我没有什麼阴影魔障 你千万不要放在心上 我又不脆弱 何况那算什麼伤 反正爱情不就都这样 我没有说谎 我何必说谎 你懂我的 我对你从来就不会假装 我哪有说谎 请别以为你有多难忘 笑是真的不是我逞强 我好久没来这间餐厅 没想到已经换了装潢 角落那窗口 闻得到玫瑰花香 被你一说是有些印象 我没有说谎 ... 阅读全文
Debugging SQL Server 2005 Stored Procedures in Visual Studio
2010-07-22 15:59 by Tracy., 451 阅读, 0 推荐, 收藏, 编辑
摘要：IntroductionWith Microsoft SQL Server 2000 it was possible to debug stored procedures from directly within Query Analyzer (see Debugging a SQL Stored Procedure from inside SQL Server 2000 Query Analyz... 阅读全文
Storing Binary Files Directly in the Database Using ASP.NET 2.0
2010-07-22 14:46 by Tracy., 478 阅读, 0 推荐, 收藏, 编辑
摘要：IntroductionIn building a data-driven application, oftentimes both text and binary data needs to be captured. Applications might need to store images, PDFs, Word documents, or other binary data. Such ... 阅读全文
Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView
2010-07-22 14:17 by Tracy., 380 阅读, 0 推荐, 收藏, 编辑
摘要：IntroductionIn November 2007 Microsoft released ASP.NET 3.5. As noted in An Overview of ASP.NET 3.5 and Visual Studio 2008, this released included two new ASP.NET data Web controls: the ListView and D... 阅读全文
Passing Information Between Content and Master Pages .
2010-07-22 14:04 by Tracy., 300 阅读, 0 推荐, 收藏, 编辑
摘要：IntroductionWhen graphic designers create a layout for a Web site, they typically break down page layout into distinct regions, such as a common header that includes the logo and various navigation li... 阅读全文
Dynamically Setting the Page's Title in ASP.NET 2.0 or By SiteMap
2010-07-22 13:46 by Tracy., 325 阅读, 0 推荐, 收藏, 编辑
摘要：Creating a Programmatically-Accessible <head> RegionOne of the many new features found in ASP.NET 2.0 is the programmatically-accessible <head> region, which can be added to an ASP.NET pag... 阅读全文
An Extensive Examination of LINQ: Querying and Searching XML Documents Using LINQ to XML
2010-07-22 13:36 by Tracy., 292 阅读, 0 推荐, 收藏, 编辑
摘要：IntroductionXML is an increasingly popular way to encode documents, data, and electronic messages. Over the years Microsoft has offered a variety of libraries to facilitate creating, modifying, queryi... 阅读全文
Fw:Managing View State in ASP.NET 4 Using the New ViewStateMode Property
2010-07-22 13:14 by Tracy., 282 阅读, 0 推荐, 收藏, 编辑
摘要：IntroductionThe ASP.NET Web Forms model strives to encapsulate the lower level complexities involved in building a web application. Features like server-side event handlers, the page lifecycle, and vi... 阅读全文
根据原文件生成指定的静态文件
2010-07-21 15:58 by Tracy., 240 阅读, 0 推荐, 收藏, 编辑
摘要：public class CreateHtmlHelper { public CreateHtmlHelper() { } /// <summary> /// 根据原文件生成指定的静态文件 /// </summary> /// <param name="_SourceFileName">原文件【虚拟路径】，如aspx</param> /// <... 阅读全文
ASPNET下的路径辅助类
2010-07-21 15:51 by Tracy., 221 阅读, 0 推荐, 收藏, 编辑
摘要：using System; using System.Web; namespace SysClassLibrary.Common { /// <summary> /// Application 的摘要说明。 /// 网站相关路径信息 /// </summary> public class Application :System.Web.HttpAppl... 阅读全文
转:Querying a Hierarchical Parent-Child Structure in LINQ
2010-07-19 17:23 by Tracy., 292 阅读, 0 推荐, 收藏, 编辑
摘要：To print the results, I am using a utility class called ObjectDumper which can be obtained from here. The structure of the classes representing a Parent-Child relationship is shown below. Each Departm... 阅读全文
转:Are You A Good Developer?
2010-07-19 16:57 by Tracy., 424 阅读, 0 推荐, 收藏, 编辑
摘要：Are You A Good Developer?'Good' means having qualities that are desirable and distinguishing. From a developer's perspective, these qualities are both technical as well as non-technical. Here are some... 阅读全文