Jump to content

Display Column name fields in a Row


maliary

Recommended Posts

 

Hello,

 

I am using MSSQL 2005 and have the following query to display table column names.

 

SELECT name FROM syscolumns WHERE ID = (SELECT id FROM sysobjects WHERE name='AADM')

 

This displays as a column, is it possible to display the name in a row instead.

Across instead of one column downwards ?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.