Blog

Concatenate row data into a single data in SQL Server

Posted by Venkatesan Jayakantham in Blogs | SQL on Apr 30, 2011

Tweet
1769
0

How to concatenate the row data into a single data?

 [CODE]
DECLARE @NAME VARCHAR(100) =''
SELECT @NAME= @NAME + ',' + 
NAME   FROM VENKAT_NAME_TABLE
SELECT 
SUBSTRING(@NAME,1,LEN(@NAME))
[/CODE]

Cheers,
Venkatesan Prabu .J
Head - www.kaashivinfotech.com
http://venkattechnicalblog.blogspot.com/

This Feature is Sponsored By

.NET Charting component with full set of charting and gauge types

comments

COMMENT USING

PREMIUM SPONSORS

DynamicPDF Developer Components

DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and add new content to existing PDF documents from within your applications.

More Blogs from this Blogger

Programmatically find out when SQL Server service is started Query to Create comma separated Output. Concatenate row data into a single data in SQL Server Uncommitted new row cannot be deleted. SET or SELECT -- is there any performance difference? Telnet client in Windows Vista Stored procedure execution on SQL Server Startup Changing the path of the MDF and LDF file for the database Inline Declaration and value assignation in SQL Server 2008 DIFFERENCE BETWEEN DROP AND TRUNCATE

View All

SPONSORED BY

Get the industry leading .NET Charting component

.NET Charting component with full set of charting and gauge types.

Follow @twitterapi

Latest Blogs

Encapsulate Field and Extract Interface in .NET No HTTP resource was found that matches the request URI in MVC 4 Web API Check Database Connection in MySQL using C# Why Developers Should Read News In Defence of Books Media Player, Real Player, QuickTime Player in ASP.Net Credit Card Payment in ASP.Net using Stripe.com Crop Image in ASP.Net using Script Creating Social Site Buttons By addthis.com in ASP.Net Internals of C# Events

View All

Poll Result All Polls


Speed of C# Corner

How do you find speed of C# Corner when visiting the site?

Very Fast OK Slow Very Slow

Options	Votes	%
Very Fast	4	6.90
OK	47	81.03
Slow	4	6.90
Very Slow	3	5.17
Total	58	100%

In Focus

Concatenate row data into a single data in SQL Server