ALTER PROCEDURE Usp_ClearDaily @TreatmentDate datetime='' AS BEGIN SET NOCOUNT ON; UPDATE DailyRecord SET [Remarks] ='' WHERE TreatmentDate = @TreatmentDate END GO
AND CONVERT(VARCHAR, [TreatmentDate],101) = CONVERT(VARCHAR, @TreatmentDate,101)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)