Web Listing 1:  Code to Create and Load Original Table with Keyword Array

/*==============================================================*/
/* Table: dbo.ASSET                                */
/*==============================================================*/
if exists (select * from dbo.sysobjects where id = object_id('dbo.ASSET') 
	and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   DROP TABLE dbo.ASSET
GO
--
create table dbo.ASSET (
	ID		int 		IDENTITY (1, 1) NOT FOR REPLICATION,
	name	 	varchar(50) 	NOT NULL ,
	asset_image 	varchar(50)  	NOT NULL ,
	keywords 	varchar(1000)  	NULL 
)  
GO
--
-- pkey  
--
ALTER TABLE dbo.ASSET
   ADD CONSTRAINT PK_ASSET PRIMARY KEY CLUSTERED (ID)
GO
--
-- Load the table.
--
begin tran
SET IDENTITY_INSERT dbo.ASSET ON
INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	388 , '7 people Strolling 1', 'strolling_1.jpg' , 'blue man dancing tribal southwest 
icon' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	4634 , '2001 MB000880' , 'MB000880.jpg' , 'touchdown team ball' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	4635 , '2001 MB000881' , 'MB000881.jpg' , 'touchdown team ball' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	4636 , '2001 MB000882' , 'MB000882.jpg' , 'touchdown team ball' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3681 , '2001 MB000905' , 'MB000905.jpg' , 'steer farm cattle cow' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3682 , '2001 MB000906'	, 'MB000906.jpg' , 'cowboy rodeo boots western 
southwest' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3683 , '2001 MB000907' , 'MB000907.jpg' , 'cowboy rodeo boots southwestern 
western' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3684 , '2001 MB000908' , 'MB000908.jpg' , 'cowboy rodeo wagon southwestern 
western' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3275, '2001 MB000916' , 'MB000916.jpg' , 'rodeo mascot' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3845 , '2001 MB000917' , 'MB000917.jpg' , 'bearded man bed')

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3846 , '2001 MB000918' , 'MB000918.jpg' , 'flower plant spring bloom' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3708 , '2001 MB000919' , 'MB000919.jpg' , 'zoo giraffe' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3711 , '2001 MB000920' , 'MB000920.jpg' , '#1 sign ballgame foam hand' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3713 , '2001 MB000921' , 'MB000921.jpg' , 'hawaii party luau')

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3714 , '2001 MB000922' , 'MB000922.jpg' , 'hawaii flower bloom spring' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3715 , '2001 MB000923' , 'MB000923.jpg' , 'hawaii flower' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3716 , '2001 MB000924' , 'MB000924.jpg' , 'hawaii dancing HULA' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3878 , '2001 MB000925' , 'MB000925.jpg' , 'mascot bird' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3723 , '2001 MB000938' , 'MB000938.jpg' , 'mascot pony horse farm' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3849 , '2001 MB000939' , 'MB000939.jpg' , 'usa president america' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3850 , '2001 MB000940' , 'MB000940.jpg' , 'usa president america' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3276 , '2001 MB000941' , 'MB000941.jpg' , 'farm rooster chicken' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3277 , '2001 MB000942' , 'MB000942.jpg' , 'scorpion spider' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3851 , '2001 MB000943' , 'MB000943.jpg' , 'skeleton halloween' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3724 , '2001 MB000944' , 'MB000944.jpg' , 'mascot dog doberman puppy canine' 
)

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3852 , '2001 MB000945' , 'MB000945.jpg' , 'snow ice weather' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3853 , '2001 MB000946' , 'MB000946.jpg' , 'snow snowman weather winter 
christmas' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3278 , '2001 MB000947' , 'MB000947.jpg' , 'rodeo mascot  bull' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3725 , '2001 MB000948' , 'MB000948.jpg' , 'beer bar party liquor' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3279 , '2001 MB000949' , 'MB000949.jpg' , 'genie' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3732 , '2001 MB000955' , 'MB000955.jpg' , 'mascot whale' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3855 , '2001 MB000956' , 'MB000956.jpg' , 'party celebration' )

INSERT INTO dbo.ASSET (ID, name, asset_image, keywords)
VALUES(	3884 , '2001 MB000957' , 'MB000957.jpg' , 'bat ball team' )
SET IDENTITY_INSERT dbo.ASSET OFF
commit

select * from dbo.ASSET