use [Northwind] GO IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetMyCustomerList]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[GetMyCustomerList] GO IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MyCustomers]') AND type in (N'U')) DROP TABLE [dbo].[MyCustomers] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[MyCustomers]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [Guid] [uniqueidentifier] NOT NULL CONSTRAINT [DF_MyCustomers_Guid] DEFAULT (newid()), [FName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_MyCustomers] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- Stuff our Table with some data Declare @Count int Set @Count = 0 While @Count < 50000 Begin Insert Into dbo.MyCustomers (FName, LName) Values (Cast(NewID() as varchar(50)), Cast(NewID() as varchar(50))) Set @Count = @Count + 1 End GO -- Create a Stroed Proc to retrive our data Create Procedure [dbo].[GetMyCustomerList] As Set NoCount On Select ID ,Guid ,FName ,LName From dbo.MyCustomers Set NoCount Off GO -- Quick Test to see if everything went right Select Top 100 * From dbo.MyCustomers Order By ID desc GO