Today I came to know that we can use CASE with ORDER BY clause. Its a nice functionality which helps you to avoid UNIOUN when you have to display the records in some specific order and still you need to sort them.
As shown below I have created an Employee table with ID (Primary [...]
Archive for April, 2008
Using CASE with ORDER BY in SQL Server
Posted in DotNet 2.0, Sql Server, Techincal on April 4, 2008 | 5 Comments »
ASP.NET Internals: Viewstate and Page Life Cycle
Posted in DotNet 2.0, Techincal on April 1, 2008 | Leave a Comment »
During the free time today, I was looking for some articles on ASP.NET internals. I found an awesome article about page life cycle and viewstate. Author has explained a viewstate in very detail and simple manner. You can read the article here.
Happy Programming!!
-
Recent Posts
c
Archives
Pages
-
Top Posts
- Call parent window's javascript function from child window OR passing data from child window to parent window in javascript
- Add items in Drop Down List or List Box using Javascript
- Storing and Retrieving doc/pdf/xls files in SQL Server
- GROUP BY, CUBE, ROLLUP and SQL SERVER 2005
- How To Create System Restore Point on Windows Server 2003
- Storing and Retrieving Image in SQL Server
- Remove/Delete element from page using JavaScript working in FireFox,IE,Opera
- How to change App.config file run time using C#
- How to use transaction in LINQ using C#
- Difference between user defined function and stored procedure
Category Cloud
-
Blog Stats
- 801,481 hits
-
Recent Comments
CyberChrist on Value does not fall within the… Chippo on Could not load file or assembl… Strikingknife on An error occurred creating the… James on Set Full Image Path in FCK… kosal on How to change App.config file … Twitter
- New blog post: http://tinyurl.com/rcd6x3 - How to detect page is loaded 3 months ago
Analytics
