Wednesday, 27 April 2016

How to List columns in alphabetical order?

SELECT name FROM sys.columns WHERE [object_id] = OBJECT_ID('tablename') ORDER BY name;

No comments:

Post a Comment