Hi Vinod,

There are so many tutorials and articles available on net to work with CLR database objects.

The basic steps to do so are.

  1. Create a new database project
  2. Provide the connection detail
  3. Add a Stored Procedure class into it
  4. Write your logic into that class
  5. Deploy the object by right click and select Deploy from the project.

You can go through more detail by following articles.

http://msdn.microsoft.com/en-us/library/ms345136.aspx

http://www.developer.com/net/net/article.php/3528601

http://msdn.microsoft.com/en-us/library/ms345106.aspx

and many more.

If you need further assistance then feel free to ask.