2004 年 7月 4 日随笔档案 - fengzhimei

2004年7月4日

摘要： I have a following Question to ask all of you: Suppose you have a table named tblRoles with column named "RoleName". Now, construct a query that will select all the role names into a single var... 阅读全文

posted @ 2004-07-04 14:55 fengzhimei 阅读(1931) 评论(2) 推荐(0) 编辑

SQL Server Performance Tip : Row-by-Row Operations Without Cursors

摘要： In general, SQL Cursors are very useful and powerful because they offer a high degree of row-level data manipulation, but this power comes at a price: negative performance. So sometimes we need to... 阅读全文

posted @ 2004-07-04 14:18 fengzhimei 阅读(1523) 评论(0) 推荐(0) 编辑

Code snippet of the day : persist the scroll position of an ASP.NET page

摘要： Sometimes we need to persist the scroll position of a page after a post back and not reset to the top, In ASP.NET 2.0, you can use the SmartNavigation feature. However, setting SmartNavigation to ... 阅读全文

posted @ 2004-07-04 12:30 fengzhimei 阅读(2654) 评论(5) 推荐(0) 编辑