Hi.... Try This....
DECLARE @Temp TABLE(Name VARCHAR(20),Age TINYINT, Total INT)
INSERT INTO @Temp(Name,Age,Total)
SELECT 'Ram',26,800
UNION ALL
SELECT 'kumar',36,300
UNION ALL
SELECT 'Sam',34,200
DECLARE @SQLStr VARCHAR(8000)
SET @SQLStr = ''
SELECT @SQLStr = @SQLStr + 'Name:' + Name + ' Age:' + CAST(Age AS VARCHAR) + ' Total:' + CAST(Total AS VARCHAR) + '; '
FROM @Temp
PRINT @SQLStr