My New Article : Quick Overview: Temporary Tables in SQL Server 2005 September 22, 2009
Posted by Abhijit Jana in My Articles, SQL Server 2005.add a comment
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 August 16, 2009
Posted by Abhijit Jana in My Articles, SQL Server 2005.1 comment so far
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 : A Closer Look Inside RAISERROR – SQLServer 2005 August 15, 2009
Posted by Abhijit Jana in My Articles, SQL Server 2005.1 comment so far
Today, I have published another article on fundamental of RAISERROR in SQL Server 2005. Its all about internal of RAISERROR, how to use it, sp_addmessage, use them inside TRY-CATCH etc. If you really interesed, Here is my complete article
My New Article : Overview of Error in SQL Server 2005 Handling August 1, 2009
Posted by Abhijit Jana in My Articles, SQL Server 2005.7 comments
Today I have published another article on Error Handling in SQL Server 2005. This is all about how we are going to handled errors and exception in T-SQL. I have described basic of @@ERROR and TRY-CATCH Block with proper example. If you are really intereseted, then please read my article here, Overview of Error Handling in SQL Server 2005
Please give your suggestion and feedback .
My New Article : Overview of VIEW in SQL Server 2005 July 29, 2009
Posted by Abhijit Jana in ASP.NET, My Articles, SQL Server 2005.2 comments
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.
First Prize winner in Competition “Best ASP.NET article of January 2009″ March 25, 2009
Posted by Abhijit Jana in ASP.NET, C#, My Articles, SQL Server 2005.2 comments
I have won the first prize for my “Exploring Session in ASP.NET” article in the month of January . Thanks to all for voting.
