摘要： 1. Performance Tuning SQL Server Cursorshttp://www.sql-server-performance.com/2007/cursors/2.Server Side Cursors and ADO Cursor Typeshttp://www.sqlteam.com/article/server-side-cursors-and-ado-cursor-types3. OffSet4.pivot table: dynamic table.5. substring function in sql to compare the text data. 阅读全文

摘要： For SQL Server 2011 you can use the enhanced ORDERBY clause.SELECT*FROM MyTable ORDER BY OrderingColumn ASC OFFSET50 ROWS FETCH NEXT 25 ROWS ONLY Thoughitremains to be seen how well performing this option will be.http://msdn.microsoft.com/en-us/library/ms188385%28SQL.110%29.aspxSQL clauseshttp://db. 阅读全文