My New Article : Quick Overview: Temporary Tables in SQL Server 2005

Just finished up with  publising a new articles on SQL Server and its 4.30 am over here  🙂 .  This article is based on the temporary tables in SQL Server 2005.  I have explained how to use them, where they stores, when to use etc.
If you are really intereseted, then please read my article complete  here, Quick Overview: Temporary Tables in SQL Server 2005
Please give your feedback and valuable suggestion to improve this article.


Most Commonly Used Functions in SQL Server 2005/2008

Lastnight I have published an article on Most Commonly Used Functions in SQL Server 2005/2008. This is quite different article than I used to published.

Objective of this article is to put all mostly used function related in SQL Server 2005/2008 under a sinlge article. There are several function that we are used regularly in SQL Server 2005/2008. This article is will a common place for all those function with proper example.

But, I need your help. This Table of Contents and Article is editable by all CodeProject  Silver members and above. What I want you to do is replace the entries in the Table of Contents below add as many as function you aware on SQL Server 2005 or above. This will really help beginners to find out all of them under a single article.

Please Visit here, Most Commonly Used Functions in SQL Server 2005/2008.

Thanks for your support.

My New Article : Overview of VIEW in SQL Server 2005

Lastnight I have published another article on fundamental of SQL Server VIEW. Its all about View Creation, Use of View, Description of System View, Schema Binding with view and Encryption of View. If you really interesed, Here is my complete article Overview of View in SQL Server 2005 .

This is the Part 1. In the next part I will write on Parameterized View and Indexing of View
Please give your valuable suggestion and feedback.