Hi all quick quesiton. Hope you can help with this one.
Is this the most effiecient way to do this? I want to display columns in MS SQL:
syscolumns.name as [Column],
syscolumns.xusertype as [Type],
sysobjects.xtype as [Objtype]
where sysobjects.id = syscolumns.id
and sysobjects.xtype = 'u'
and sysobjects.name = 'tblAssociation'
order by syscolumns.name