Thank you for your reply,

SELECT SUBSTRING ( (SELECT ', ' +'['+ Name+']' FROM sys.columns WHERE object_name(object_id) = 'emp_details' ORDER BY object_id FOR XML PATH('')), 2,100)

Using this query am getting a row of column names from one table.

The result like "[name], [address], [state], [pin_code]"

Thees are all column names...

for example below query will displays all values of mentioned column names

select [name], [address], [state], [pin_code] from emp_details

But I don't like to type column names manually, instead of that am using 1st query which I have mentioned.

Like below query,

select SELECT SUBSTRING ( (SELECT ', ' +'['+ Name+']' FROM sys.columns WHERE object_name(object_id) = 'emp_details' ORDER BY object_id FOR XML PATH('')), 2,100) from emp_details

When am executing this query am getting result like below for all rows.

[name], [address], [state], [pin_code]

[name], [address], [state], [pin_code]

[name], [address], [state], [pin_code]

[name], [address], [state], [pin_code]

[name], [address], [state], [pin_code]

[name], [address], [state], [pin_code]

[name], [address], [state], [pin_code]