LISTING 4: Testing the ORDER BY Clause

DROP TABLE NoOrderByClauseOnGUID
GO
CREATE TABLE NoOrderByClauseOnGUID
(
RowIdent int IDENTITY
,RowGUID uniqueidentifier DEFAULT newid()
)
GO


Declare @NumInsert int
SET @NumInsert = 0
SET NOCOUNT ON
BEGIN TRAN
WHILE @NumInsert < 100
BEGIN
	INSERT INTO NoOrderByClauseOnGUID  DEFAULT VALUES
	SET  @NumInsert = @NumInsert  + 1
END
COMMIT TRAN
GO

CREATE UNIQUE CLUSTERED INDEX TestGUIDOrder ON 
NoOrderByClauseOnGUID(RowGUID)
GO