sql query with like key words.

• pkuchaliya

  Say Hey Kid

  Points: 671

  More actions

  August 4, 2008 at 7:47 am

  #191974

  /****** Object: Table [dbo].[Help_DishaSiteMap] Script Date: 08/04/2008 19:09:54 ******/

  IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Help_DishaSiteMap]') AND type in (N'U'))

  DROP TABLE [dbo].[Help_DishaSiteMap]

  GO

  /****** Object: Table [dbo].[Help_DishaSiteMap] Script Date: 08/04/2008 19:09:54 ******/

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Help_DishaSiteMap]') AND type in (N'U'))

  BEGIN

  CREATE TABLE [dbo].[Help_DishaSiteMap](

  [LinkId] [int] IDENTITY(1,1) NOT NULL,

  [LinkName] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [LinkURL] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [description] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [keywords] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  CONSTRAINT [PK_Help_DishaSiteMap] PRIMARY KEY CLUSTERED

  (

  [LinkId] ASC

  )WITH (IGNORE_DUP_KEY = OFF)

  )

  END

  GO

  SET IDENTITY_INSERT [dbo].[Help_DishaSiteMap] ON

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (1, N'Course Master', N'http://192.168.0.53/Student_Module/student_module/course_mast.aspx', N'temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp ', N'Description xcvxcvx')

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (2, N'Fee Master', N'http://192.168.0.53/Student_Module/student_module/fee_master.aspx', N'anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anuanudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anudeep

  anu

  lngs,.n,.msng

  skljgklns,m.ngf', N'Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Desedddddddddddddd')

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (3, N'Subject Master', N'http://192.168.0.53/Student_Module/student_module/Master_Data.aspx', N'gvvv', N'fff')

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (4, N'Subject - Semester Master', N'http://192.168.0.53/Student_Module/student_module/Master_Data.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (5, N'Exam Master', N'http://192.168.0.53/Student_Module/Exam_Module/MAST_EXAM.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (6, N'Employee Entry ', N'http://192.168.0.53/Student_Module/Employee/emp1.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (7, N'Designation', N'http://192.168.0.53/Student_Module/student_module/Desig_Hall.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (8, N'Time Table Preparation', N'http://192.168.0.53/Student_Module/student_module/nTimeTable.aspx', N'Time Table Description', N'Time Table Description')

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (9, N'Time Table Editing', N'http://192.168.0.53/Student_Module/student_module/AdminTimeTable/TimeTableEditing.aspx', N'ffff', N'ff')

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (10, N'Exam Date sheet', N'http://192.168.0.53/Student_Module/Exam_Module/Exam_Time_Table.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (11, N'Admission Entry', N'http://192.168.0.53/Student_Module/student_module/admission_committee.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (12, N'Student - Batch Allotment', N'http://192.168.0.53/Student_Module/student_module/STUDENT_BATCH.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (13, N'Student - University-Dimat ID', N'http://192.168.0.53/Student_Module/student_module/frmUniversityID.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (14, N'Generate Period', N'http://192.168.0.53/Student_Module/AccessControl/frmPrdSmry_ACS.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (15, N'Generate Shift', N'http://192.168.0.53/Student_Module/AccessControl/frmShift_setup_AS.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (16, N'HoliDay Setup', N'http://192.168.0.53/Student_Module/AccessControl/frmholiday_Setup.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (17, N'Student Leave Post', N'http://192.168.0.53/Student_Module/AccessControl/Leave_setup.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (18, N'Faculty Manual Punch', N'http://192.168.0.53/Student_Module/AccessControl/frm_Manual_Punch.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (19, N'Staff Manual Punch', N'http://192.168.0.53/Student_Module/AccessControl/frm_staff_Manual_pnch.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (20, N'Student Manual Punch', N'http://192.168.0.53/Student_Module/AccessControl/frm_Stu_Manual_pnch.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (21, N'HR Panel', N'http://192.168.0.53/Student_Module/HR_module/HR_Panel_Login.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (22, N'HR Recruitment Process', N'http://192.168.0.53/Student_Module/HR_module/Recruitment_panel.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (23, N'Employee Panel', N'http://192.168.0.53/Student_Module/HR_module/Hr_Employee_Panel.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (24, N'Course-Semester-Faculty', N'http://192.168.0.53/Student_Module/student_module/Faculty.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (25, N'Time Table Editing', N'http://192.168.0.53/Student_Module/student_module/TimeTableEditing.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (26, N'Lecture Hall', N'http://192.168.0.53/Student_Module/student_module/Desig_Hall.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (27, N'Attendance Mark', N'http://192.168.0.53/Student_Module/student_module/student_attend.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (28, N'Student List', N'http://192.168.0.53/Student_Module/student_module/Student_Report/rpt_student_admin.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (29, N'Exam Marks Entry', N'http://192.168.0.53/Student_Module/Exam_Module/EXAM_MARKS.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (30, N'Exam Attendance', N'http://192.168.0.53/Student_Module/Exam_Module/exam_attend.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (31, N'Fee Submission ', N'http://192.168.0.53/Student_Module/student_module/fee.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (32, N'Student Attendance Report', N'http://192.168.0.53/Student_Module/student_module/attend_reports/AttendeceReport.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (33, N'Faculty Attendance Report', N'http://192.168.0.53/Student_Module/AccessControl/frmFacltyAttn_ACS.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (34, N'Faculty Day Attendence', N'http://192.168.0.53/Student_Module/AccessControl/frmFacltyAttn_ACS.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (35, N'Student Attendence Report', N'http://192.168.0.53/Student_Module/AccessControl/frmSTDAttn_ACS.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (36, N'Staff Attendence Report', N'http://192.168.0.53/Student_Module/AccessControl/fr_staff.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (37, N'Faculty Punch Details', N'http://192.168.0.53/Student_Module/AccessControl/frmFacltyPnchDtl_Admin.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (38, N'Student Punch Detail', N'http://192.168.0.53/Student_Module/AccessControl/frmStuPnchDtl_Admin.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (39, N'Staff Punch Detail', N'http://192.168.0.53/Student_Module/AccessControl/frmOtherStaffPnchDtl_Admin.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (40, N'Manual Punch Report', N'http://192.168.0.53/Student_Module/HR_module/HR_Reports_UI/AprslReportMain.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (41, N'Employee Reports', N'http://192.168.0.53/Student_Module/HR_module/HR_Reports_UI/frm_HR_empdetls_RPt_UI.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (42, N'Complaint Report', N'http://192.168.0.53/Student_Module/HR_module/HR_Reports_UI/ComplaintReportMain.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (43, N'Appraisal Reports', N'http://192.168.0.53/Student_Module/HR_module/HR_Reports_UI/AprslReportMain.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (44, N'Employee FeedBack Report', N'http://192.168.0.53/Student_Module/HR_module/frm_Hr_Emp_FeedbackReport.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (45, N'Official Visit Report', N'http://192.168.0.53/Student_Module/HR_module/frm_Hr_Emp_StaffManagementReport.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (46, N'Self Evaluation Report', N'http://192.168.0.53/Student_Module/HR_module/frmEmp_SelEvaluationReports.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (47, N'Time Table Report', N'http://192.168.0.53/Student_Module/student_module/Time%20Table%20Report.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (48, N'Faculty Load Report', N'http://192.168.0.53/Student_Module/student_module/Time%20Table%20Report.aspx?fl=1', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (49, N'Class Test Result Report', N'http://192.168.0.53/Student_Module/Exam_Module/frmClassTestResultReport.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (50, N'Class Test Result Analysis Report', N'http://192.168.0.53/Student_Module/Exam_Module/frmCTMarksReport.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (51, N'Semester wise Result Analysis Report', N'http://192.168.0.53/Student_Module/Exam_Module/frmSemesterWiserResultAnalysis.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (52, N'Exam Attendance Report', N'http://192.168.0.53/Student_Module/Exam_Module/RPT_STUD_ATTEND.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (53, N'Invigilator Report', N'http://192.168.0.53/Student_Module/ReportsAS/frmDutyChartContainer.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (54, N'Class Test & Teacher Assessment Report ', N'http://192.168.0.53/Student_Module/Exam_Module/frmfullExamReports.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (55, N'Fee Collection Report', N'http://192.168.0.53/Student_Module/UnderConstruction.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (56, N'Partial Payment Report', N'http://192.168.0.53/Student_Module/UnderConstruction.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (57, N'Defaulters List', N'http://192.168.0.53/Student_Module/UnderConstruction.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (58, N'Bank Instrument Realization', N'http://192.168.0.53/Student_Module/UnderConstruction.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (59, N'Fee Receipt', N'http://192.168.0.53/Student_Module/UnderConstruction.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (60, N'Student Fee Register ', N'http://192.168.0.53/Student_Module/UnderConstruction.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (61, N'Calendar ', N'http://192.168.0.53/Student_Module/Calendar/Calendar.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (62, N'Event Entry', N'http://192.168.0.53/Student_Module/Calendar/AddEvents.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (63, N'Alumni Login', N'http://192.168.0.53/Student_Module/Alumni/Lgin.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (64, N'View Profile', N'http://192.168.0.53/Student_Module/Alumni/View_member.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (65, N'Online Exam', N'http://192.168.0.53/Student_Module/Examination/ExamSelection.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (66, N'Exam Administration', N'http://192.168.0.53/Student_Module/Examination/Admin/Index.aspx', NULL, NULL)

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (69, N'temp', N'http://192.168.0.53/Student_Module/Examination/Adm', N'temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp ', N'temp')

  INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (70, N'temp', N'http://192.168.0.53/Student_Module/student_module/', N'temp', N'temp')

  SET IDENTITY_INSERT [dbo].[Help_DishaSiteMap] OFF

  i want to make a query that will search any no of keywords.

  suppose if user give anudeep and description. then it search in table, and display the result which column found the anudeep and description. and user may be give any number of parameter.

• Christopher Stobbs

  SSC-Insane

  Points: 21098

  More actions

  August 4, 2008 at 7:54 am

  #852687

  IS this the same question as this:

  http://qa.sqlservercentral.com/Forums/Topic546066-338-1.aspx?Update=1

  ----------------------------------------------
  Try to learn something about everything and everything about something. - Thomas Henry Huxley

  :w00t:
  Posting Best Practices[/url]
  Numbers / Tally Tables[/url]

  SQL-4-Life

• Christopher Stobbs

  SSC-Insane

  Points: 21098

  More actions

  August 4, 2008 at 8:00 am

  #852693

  In your above example, is description a word to be searched or does it mean search for anudeep in the description column?

  THanks

  ----------------------------------------------
  Try to learn something about everything and everything about something. - Thomas Henry Huxley

  :w00t:
  Posting Best Practices[/url]
  Numbers / Tally Tables[/url]

  SQL-4-Life

• Christopher Stobbs

  SSC-Insane

  Points: 21098

  More actions

  August 4, 2008 at 8:19 am

  #852704

  Ok I got a solution for you!

  Please not the proc requires a Tally table if you don't have one the code for it is commented out in the beginning of the proc.

  CREATE PROCEDURE dbo.MyProc

  (@vcSearch VARCHAR(8000))

  AS

  --This Procedure Requires a Tally Table

  /*

  --===== Create and populate the Tally table on the fly

  SELECT TOP 11000 --equates to more than 30 years of dates

  IDENTITY(INT,1,1) AS N

  INTO dbo.Tally

  FROM Master.dbo.SysColumns sc1,

  Master.dbo.SysColumns sc2

  --===== Add a Primary Key to maximize performance

  ALTER TABLE dbo.Tally

  ADD CONSTRAINT PK_Tally_N

  PRIMARY KEY CLUSTERED (N) WITH FILLFACTOR = 100

  --===== Allow the general public to use it

  GRANT SELECT ON dbo.Tally TO PUBLIC

  */

  --DELIMIT YOUR STRING TO A TABLE.

  ;WITH MyCTE (Search)

  AS

  (SELECT TOP 1000 '%' + SUBSTRING(@vcSearch+',', n,

  CHARINDEX(',', @vcSearch+',', n) - n) + '%'

  FROM dbo.Tally

  WHERE n <= LEN(@vcSearch)

  AND SUBSTRING(',' + @vcSearch,

  n, 1) = ','

  ORDER BY n)

  --USER THE TABLE TO SEARCH YOUR TABLE

  SELECT t.*

  FROM [Help_DishaSiteMap] t

  INNER JOIN MyCTE cte

  ON [description] like cte.Search

  RETURN

  GO

  EXEC dbo.MyProc 'anudeep,temp'

  The input param to the proc is a , seperated file. so you can pass 'anudeep' or 'anudeep,temp,Chris,whateva'.

  AS long you you put a comma between each search item.

  This proc only searches the description column I think that is what you were looking for.

  ----------------------------------------------
  Try to learn something about everything and everything about something. - Thomas Henry Huxley

  :w00t:
  Posting Best Practices[/url]
  Numbers / Tally Tables[/url]

  SQL-4-Life