Listing 1: Code for Example 1

CREATE PROCEDURE [dbo].[uspMyProc] AS
  SELECT TOP 1 * FROM [dbo].[utbMyTable]
GO
CREATE TABLE [dbo].[utbMyTable] 
  ([MyCol1] INT, [MyCol2] NVARCHAR(32))
GO