Enterprise .NET Community: Build a Data Access Layer with the Visual Studio 2005 DataSet Designer: ASP.NET.4GuysFromRolla.com: Custom Paging in ASP.NET 2.0 with SQL Server 2005: SELECT RowNum, EmployeeID, LastName, FirstName FROM (SELECT EmployeeID, LastName, FirstName ROW_NUMBER() OVER(ORDER BY EmployeeID) as RowNum FROM Employees e ) as EmployeeInfo… Read More
Partitioned Tables and Indexes System Enhancements for Administrators SQL Server 2005 provides support for partitioned tables and indexes. This allows a table to be spread across a number of physical file groups, improving performance and making it easier to manage range-based archiving procedures. Table data spread across file groups You can partition a table horizontally so that the rows… Read More
中国語検索時にミス 自家製の辞典で中国語検索時にミスがありまして、調べた結果は： パラメータオブジェクトのデータ型をAnsiStringに指定しています。 これをStringに変更したら、OKです。 よかった！！！… Read More