Display the particular column value in one row

If u wanna display the particular column value in one row with Comma separated
The idea behind of that is only depends on self join

DECLARE @str VARCHAR(8000)
SELECT @str = COALESCE(@str+',','')+(SELECT UserID FROM UserMaster UM1 WHERE UM1.UserPKID = UM2.UserPKID ) FROM usermaster UM2
SELECT @str

The Result like this
------------------------
SHANKAR,HARI,SELVAM,RAMESH,DHINA,ASIF,RAJESH,SIVA,AMBRISH,RAMU

Data Base -SQL Server

To find out 5 th Maximum Salary

select top 1 max(sal) from salary where
sal not in (select top 4 max(sal) from salary group by sal order by sal desc )


To find out 5 th value from Top
select top 1 * from salary where sal not in (select top 4 sal from salary )

Alter table

// Modify the column datatype
alter table sam
alter column hi int

//Add new column
alter table sam
add age int

Modify Column name

Modify the Column name in Sql server

sp_rename 'TableName.[OldColumn]','NewColumn','COLUMN'

java script

http://www.gatescript.com/objects2.asp?f_field=Window
http://www.w3schools.com/js/js_obj_string.asp
http://webdevelopersjournal.com/articles/javascript_limitations.html
http://www.js-x.com/javascript/ref_js15/object.php
http://www.kryogenix.org/code/browser/sorttable/

Dot Net

http://support.microsoft.com/default.aspx?scid=kb;en-us;308448
http://www.objectinnovations.com/CourseOutlines/423.html
http://www.dotnetjohn.com/articles.aspx?articleid=32
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetcomp/html/httpcomm.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetcomp/html/httpcomm.asp
http://www.metabuilders.com/Tools/OneClick.aspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmtphn2k3/html/Smartphone_2003.asp

XSL

http://nwalsh.com/docs/tutorials/xsl/xsl/slides.html

E-Books

http://www.maththinking.com/boat/booksIndex.html

Freshers Stuff

http://jminds.hollosite.com/index.html

C#

HttpContext.Current.Response.Write()

Dot Net

http://www.programmersheaven.com/

ADO DOT NET

http://www.startvbdotnet.com/

General Links

http://www.geocities.com/vivekjain_meerut/HomePage/funstuff/quotes.htm

Oracle Tips

http://www.akadia.com/

Intrerface Vs Abstract in C#

http://www.code101.com/Code101/DisplayArticle.aspx?cid=20

Frequently asked Questions in C++

http://www.tietovayla.fi/borland/cplus/faq/faqcpptc.htm

Useful C# Sites.....

http://www.dotnetfun.com
 
http://www.samspublishing.com/articles/
 
http://www.devarticles.com/
 
http://www.dotnetalbum.com

Useful SQL Sites

http://www.devguru.com/Technologies/jetsql/quickref/statements.html

http://www.w3schools.com/sql

http://www.cryer.co.uk/brian/sqlserver/howtolistallindexes.htm

Useful Asp.net Websites..........

http://www.andymcm.com/dotnetfaq.htm

http://www.code101.com/Code101/Kbupdates.aspx

http://www.dotnetcoders.com/web/Apps/Quiz/default.aspx

http://aspauthors.com/aspnetbyexample/

http://www.code101.com/

Sankar--