>>The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common >> table expressions, unless TOP or FOR XML is also specified >>>>
>>TEXT TO cSqlCommand TEXTMERGE NOSHOW >> IF NOT exists (SELECT sys.tables.name, sys.indexes.name, sys.columns.name FROM sys.indexes >> INNER JOIN sys.tables ON sys.tables.object_id = sys.indexes.object_id >> INNER JOIN sys.index_columns ON sys.index_columns.index_id = sys.indexes.index_id >> AND sys.index_columns.object_id = sys.tables.object_id >> INNER JOIN sys.columns ON sys.columns.column_id = sys.index_columns.column_id >> AND sys.columns.object_id = sys.tables.object_id >> WHERE sys.tables.name = 'MYTABLE' and sys.indexes.name = 'MYINDEX' >> ORDER BY >> sys.tables.name, >> sys.indexes.name, >> sys.columns.name ) >> BEGIN >> CREATE NONCLUSTERED INDEX <<tcIndexTag>> ON [dbo].[<<tcTableName>>] ([<<tcFieldName>>]) >> SELECT CAST(1 AS bit) AS col_added >> END >> ELSE >> SELECT CAST(0 AS bit) AS col_added >>ENDTEXT >>>