Listing 2: Creation Script for the T1 Table and the VSortedT1TOP View
USE tempdb

CREATE TABLE T1
(  keycol  int NOT NULL PRIMARY KEY,
   datacol varchar(10) NOT NULL )

SET NOCOUNT ON
INSERT INTO T1 VALUES(1, 'b')
INSERT INTO T1 VALUES(3, 'a')
INSERT INTO T1 VALUES(2, 'c')
GO

CREATE VIEW VSortedT1TOP
AS
SELECT TOP 100 PERCENT *
FROM T1 ORDER BY keycol
GO