order by vista

SELECT     TOP (100) PERCENT

CREATE VIEW ejemploVista AS SELECT TOP 100 PERCENT * FROM procesos ORDER BY id DESC GO


fuente