Sample Prime Script for the Contacts Example

ContactsPrimeScript.sql

DECLARE @Date SMALLDATETIME,
		@NumberOfContacts INT,
		@Cntr INT,
		@ContactID INT,
		@FirstName NVARCHAR(64),
		@LastName NVARCHAR(64)		

/* ------------------------------------- */
/* -- DEFINE THE NUMBER OF CONTACTS ---- */
/* ------------------------------------- */

SET @NumberOfContacts = 20

/* ------------------------------------- */

SET @Date = GETDATE()
SET @Cntr = (SELECT COUNT(*) FROM dbo.Contacts)

IF(@Cntr >= @NumberOfContacts)
BEGIN
	SET @NumberOfContacts = @NumberOfContacts + @Cntr
END

-- Spice up your temp data a bit with some random names ...
CREATE TABLE #TEMP (FirstName NVARCHAR(64), LastName NVARCHAR(64))
INSERT INTO #TEMP(FirstName, LastName)
SELECT 'Tom','Smith'		UNION ALL
SELECT 'David','Freeney'	UNION ALL
SELECT 'Sally','Thompson'	UNION ALL
SELECT 'Tim','Jones'		UNION ALL
SELECT 'Chris','Dunham'		UNION ALL
SELECT 'Adam','Leeper'		UNION ALL
SELECT 'Nick','Houston'		UNION ALL
SELECT 'Jessica','McFarland'UNION ALL
SELECT 'Maddix','House'		UNION ALL
SELECT 'Dinah','Black'		UNION ALL
SELECT 'Scott','Manning'	UNION ALL
SELECT 'Missy','Hawk'		UNION ALL
SELECT 'Sara','Hassel'		UNION ALL
SELECT 'Jason','Green'	

WHILE(@Cntr < @NumberOfContacts)
BEGIN
	SET @ContactID = NULL
	SET @FirstName = (SELECT TOP 1 FirstName FROM #TEMP ORDER BY NEWID())
	SET @LastName = (SELECT TOP 1 LastName FROM #TEMP ORDER BY NEWID())
	
	INSERT INTO dbo.Contacts
           (FirstName,LastName,Phone,Address,City,State,Zip,Country,Company,Website,EmailAddress,IsActive,CreatedDate,ModifiedDate)
     VALUES
           (@FirstName
           ,@LastName
           ,'202-456-2121'
           ,'1600 Pennsylvania Ave'
           ,'Washington'
           ,'DC'
           ,'20500'
           ,'United States'
           ,'The White House'
           ,'http://www.whitehouse.gov'
           ,'someone+' + CONVERT(NVARCHAR, @Cntr) + '@gmail.com'
           ,1
           ,GETDATE()
           ,GETDATE())
	
	SET @Cntr = @Cntr + 1       	
END

DROP TABLE #TEMP
SELECT COUNT(*) AS 'Total Number of Contacts' FROM dbo.Contacts WITH (NOLOCK)
GO