Listing 1: Creating and Populating Table T1 and Creating View V1
SET NOCOUNT ON;
USE tempdb;
GO
IF OBJECT_ID('dbo.V1', 'V') IS NOT NULL DROP VIEW dbo.V1;
IF OBJECT_ID('dbo.T1', 'U') IS NOT NULL DROP TABLE dbo.T1;
GO
CREATE TABLE dbo.T1(col1 INT);
INSERT INTO dbo.T1(col1) VALUES(2);
INSERT INTO dbo.T1(col1) VALUES(1);
INSERT INTO dbo.T1(col1) VALUES(3);
GO
CREATE VIEW dbo.V1
AS
SELECT TOP 100 PERCENT col1 FROM dbo.T1 ORDER BY col1
GO