hai, i had wrote one storedprocedure for deleting the current leaves.but when i am debugging i am getting the error as invalid object name.i am posting the code. USE [HDCHRMSDB] GO /****** Object: StoredProcedure [dbo].[apDeleteCurrentYearLeaveSummery] Script Date: 01/04/2011 12:23:41 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER Procedure [dbo].[apDeleteCurrentYearLeaveSummery] As BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DELETE FROM CurrentYearLeaveSummery Where Year=2011 END please suggest any answer to avoid that error.urgent for me.

hi, i am doing one task in my project.i need to update the holidays in the frontend(ASP.NET).but when i am entering the data it is not getting saved and displaying data as "holiday id cannot allow null values". i checked in the backend there is no problem in that it is displaying correctly. only problem is front end. In the holiday id identity specifications i incremented the properties.eventhough error is coming. insert into HolidayList(Holiday,Date,Day) values (@Holiday,@Date,@Day); select HolidayId = SCOPE_IDENTITY(); the query used in the sqlserver.in this we are not declaring the holidayid but when we are executing it automatically gets incremented.suppose there are 6 values in table if we enter the next value it automatically displays as 7 value and getting exeuted. but when coming to the front end it is not saving the data.when we are clicking on the save the page is getting refreshed. please give me the solution.it is very urgent for me. thanks Amala

modified on Tuesday, December 28, 2010 10:11 AM