Try this:
CREATE TABLE [dbo].[UserInfo](
[Id] INT IDENTITY (1,1),
[Name] [nvarchar](256) NOT NULL,
[Family] [nvarchar](256) NOT NULL,
[PostalCode] [nvarchar](256) NOT NULL,
[Address] [nvarchar](256) NOT NULL,
[Telephone] [nvarchar](256) NOT NULL,
)
INSERT [dbo].[UserInfo]
SELECT 'Kuthuparakkal', 'KU', '30084', 'New York', '078-211-0000'
UNION
SELECT 'Uthuparakkal', 'UT', '30074', 'Old York', '068-211-0000'
UNION
SELECT 'Thuparakkal', 'TH', '30064', 'Bad York', '058-211-0000'
UNION
SELECT 'Huparakkal', 'HU', '30054', 'Better York', '048-211-0000'
UNION
SELECT 'Uparakkal', 'UP', '30044', 'Best York', '038-211-0000'
UNION
SELECT 'Parakkal', 'PA', '30034', 'Worst York', '028-211-0000'
GO
DECLARE @Query NVARCHAR(MAX)
SELECT @Query = COALESCE(@Query + '+ ', '') +
ISNULL(Name, 'N/A')
FROM
(
SELECT ''',' + name + '=''+' + ' CAST(ISNULL([' + name + '], ''<Empty>'') AS NVARCHAR(300)) ' AS Name
FROM sys.columns WHERE object_id = OBJECT_ID('[dbo].[UserInfo]')
)AS X
SET @Query = 'SELECT ''' + SUBSTRING(@Query,3, LEN(@Query)) + 'FROM [dbo].[UserInfo] WHERE [Id] = '
PRINT @Query
DECLARE @Rows INT = (SELECT COUNT(1) FROM [dbo].[UserInfo])
DECLARE @QueryResults AS TABLE
(
Result NVARCHAR(MAX)
)
DECLARE @TempQuery NVARCHAR(MAX)
WHILE(@Rows > 0)
BEGIN
SET @TempQuery = @Query + ''''+ CAST(@Rows AS NVARCHAR(300)) + ''''
INSERT @QueryResults
EXEC (@TempQuery)
SET @Rows = @Rows -1
END
SELECT * FROM @QueryResults
Thanks,
Kuthuparakkal