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.


Written by Abhijit Jana

I am a Modern and Cloud App Development Consultant working at Microsoft. Presently I am focusing on adopting and delivering world class solution on N+1 Technologies, where I mainly drive engagements on Universal Windows Platforms, Microsoft Azure, IoT and Cross Platform and Device related application Development. I am a former Microsoft MVP, Author of Kinect for Windows SDK and HoloLens BluePrints book and Run Daily .NET Tips . To know more about me click here.

One comment

  1. Hi,
    I read your Raiserror article. It will be quite useful for me. I have an issue in my application.
    In my case,application is handling PK key violation using MsgId 2627 .While migrating to 2008,there is an issue for handling such violation.Can you tell me is there any way to change default PK key violation id 50000 to previous 2627
    Thanks in adv


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s