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]