2006年04月_DillonHunter

原创 SQL Server 2005 存储过程分页

create table t1( id int, s1 int)Declare @i intset @i=1while(@ibegin insert into t1 values(@i+1,@i) set @i=@i+1endselect t.id,t.s1,t.pos from (select *,row_number() over (order by s1 desc) as pos f

2006-04-26 13:35:00 902

原创用存储过程万能分页显示表数据

CREATE PROCEDURE GetRecordFromPage @tblName varchar(255), -- 表名 @fldName varchar(255), -- 字段名 @PageSize int = 10, -- 页尺寸 @PageIndex int = 1,

2006-04-20 01:07:00 901

原创显示表结构的SQL

select 表名=case when a.colorder=1 then d.name else end, 表说明=case when a.colorder=1 then isnull(f.value,) else end, 字段序号=a.colorder, 字段名=a.name, 标识=case when columnproperty( a.id,a.name,isi

2006-04-19 16:32:00 1082

原创 Blogs Sites URL

http://terrylee.cnblogs.com/

2006-04-18 23:13:00 962

原创使用SQL语句实现SPLIT效果的几种方法

CREATE TABLE [TABLE1] ( [id] [int] IDENTITY (1, 1) NOT NULL , [name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_TABLE1] PRIMARY KEY CLUSTERED ( [id] ) ON [PRIMARY] ) ON [PRIMARY]

2006-04-18 21:41:00 7441

原创 CSharp Code Snippets's Sites

Siteshttp://www.gotcodesnippets.net/

2006-04-14 16:12:00 908

原创 Good Books that I must learn

iso9000-2000实施概要.pdfISO9000管理教练宣言.pdfStruts 学习笔记.docStruts原理、开发及项目实施.docstruts实践经验.pptstruts对传统问题的解决办法.pptstruts架构和标签库介绍.docstruts框架详细介绍.pptstruts的结构.docLink:http://blog.dev-club.esnai.com/qrf/artic

2006-04-12 22:50:00 889

[前言] 写这篇Post源于我既做过.NET开发又做过J2EE开发的经历。在这样的转变过程中，我对单一平台开发所带来的思维局限性有了很多清晰却零散的想法。在看了振河兄的页面间传递变量的方法及使用范围的讨论之后，我更能体会到在不同的平台进行开发，思维方式会是如此之不同，原来那些零散的想法也随之不断在脑海中涌现，让我有了写下这篇Post的冲动。其实我一直都在宣扬一种观点：技术之间是相通的，精于触类旁通

2006-04-12 22:38:00 785

原创 Collect UML's Reference Books and Sits

Reference BooksAuthor: Martin FowlerBooks:UML Distilled Author:Philippe KruchtenBooks:The Rational Unified Process:An Introduction Author: Booch Jacobson

2006-04-12 22:17:00 802

原创 Industrial Engneering Sites

http://www.chinaie.info/

2006-04-06 14:26:00 1256

原创 Blog Sites URL

ccBoys(小气的神) BLOGwww.dotnettools.org

2006-04-06 11:26:00 840

原创 eclipse

http://www.eclipse.org/

2006-04-04 15:13:00 759

原创 UML and Bugfree Site

Learn UML Fileswww.umlchina.comUML Rule Sitehttp://www.omg.com/Enterprise Architecturehttp://www.sparxsystems.com.au/Bug Managerhttp://bugfree.1zsoft.com/www.itpub.net

2006-04-04 12:53:00 893

原创 Rational Unifiad Process

http://www.augustana.ab.ca/~mohrj/courses/2000.winter/csc220/papers/rup_best_practices/rup_bestpractices.html UMl Process

2006-04-04 12:30:00 870

原创 ASP.NET Membership

http://www.dotnetgenerics.com/Modules/ASP.NET/Membership.aspxStep-by-step process to get the ASP.Net membership provider up and running and using the user security related controls

2006-04-03 12:37:00 977

原创枚举 ENum

using System;using System.Collections.Generic;using System.Text;namespace TestENum{ class Program { enum Colored { red, green, blue } static void Main(s

2006-04-03 10:08:00 851

转载在.NET环境中使用单元测试工具NUnit

namespace UnitTestingExamples { using System; using NUnit.Framework; [TestFixture] public class SomeTests { [TestFixtureSetUp] public void RunBeforeAllTests() { Console.WriteLine( “TestFixtureSetUp” )

2006-04-02 13:30:00 789

DillonHunter的专栏