|
pkuchaliya
Starting Member
49 Posts |
 Posted - 2008-08-04 : 10:03:08
|
| /****** 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 ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Help_DishaSiteMap]') AND type in (N'U'))BEGINCREATE 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))ENDGOSET IDENTITY_INSERT [dbo].[Help_DishaSiteMap] ONINSERT [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'anudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanuanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanudeepanulngs,.n,.msngskljgklns,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 now the problem is that , i have to write the query that will search given keyword in table and search the keywords in description fields. user can give like pankaj sanjeet description . if if found any match out of them. then it will display the result. and user can give any number of search keywords.please help anyone.pankaj |
|
help me , like keyword operation