Malyalam Dictionary Orkut Application

I have created my first orkut application. An english - Malayalam Dictionary. Same as one in my home page.
http://www.orkut.co.in/Main#AppInfo.aspx?appId=160907011366

Free ASP.NET MVC Book

ASP.NET MVC Book written by Scott gu,Scott Hanselman, Rob Conery, and Phil Haack

http://www.amazon.com/gp/product/0470384611?ie=UTF8&tag=scoblo04-20&linkCode=xm2&camp=1789&creativeASIN=0470384611

First chaptter of this book is available as a Free Download. 185 pages of walk-through that takes us into creating a complete MVC application (Called Nerddinner) from scratch. Check the application live at http://www.nerddinner.com/. Source code available at codeplex http://nerddinner.codeplex.com/

Download the e-book and source code from scott gu's blog.
http://weblogs.asp.net/scottgu/archive/2009/03/10/free-asp-net-mvc-ebook-tutorial.aspx

Also check scott hanselman's blog about it.
http://www.hanselman.com/blog/FreeASPNETMVCEBookNerdDinnercomWalkthrough.aspx

SQL Server- Get Rows AS XML, Traverse XML in TSQL

I have a table 'Tags' , see below


To get the rows as XMl

SELECT * FROM Tags for xml auto

The result will be

I want to get the tags separated by coma for the given music id, i wrote a function that
will traverse the XML and return the tags as a single row separated by coma

CREATE FUNCTION [dbo].GetMusicTags
(
 @MusicID INT
)
RETURNS VARCHAR(MAX)
AS
BEGIN
DECLARE @Xdoc XML
DECLARE @Count INT
DECLARE @i INT
DECLARE @Tag VARCHAR(MAX)
DECLARE @Temp VARCHAR(MAX)
--
SET @i=1
SET @Tag=''
SET @Temp=''
--
SET @Xdoc=''+(SELECT * FROM Tags WHERE MusicID=@MusicID  for xml auto)+''
SET @Count = @Xdoc.query('
                        { count(/doc/Tags) }
                    ').value('e[1]','VARCHAR(MAX)') 

 WHILE @i <= @Count
 BEGIN
  SELECT @Temp= e.x.value('@Tag[1]', 'VARCHAR(MAX)') FROM
    @Xdoc.nodes('/doc/Tags[position()=sql:variable("@i")]') e(x)  
  SET @Tag=@Tag+@Temp  
  IF @i<>@Count 
   SET @Tag=@Tag+','
  SET @i = @i + 1
 END
RETURN @Tag
END
GO

Result will be


Download Sql Script