mercredi 10 février 2016

Selecting column names from a query NOT a view

Is it possible to get column names from a query like you can get them from a view? The view example is below.. I cannot use the view example as these are queries created by users and will potentially be amended often..

SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('dbo.ViewName')

Thank you in advance..

Derek.

Aucun commentaire:

Enregistrer un commentaire