يعطيكم العافية
أنا أقوم ببناء قادح و هذا الكود الخاص به
-- Create Triggers ------------------------------------------------------------------------------ -- Trigger on AnalysisDetails for Normailty field from ItemRange field Create Trigger Trigger_AnalysisDetail_Normailty On AnalysisDetail Instead of Insert AS Begin Declare @Result Int Declare @Min Int Declare @Max Int Declare @Normality Int Declare @Sex Bit -- Declare @Age TinyInt -- Get Patient Data Select @Sex = P.Sex -- @Age = P.Age From PatientInfo P , Analysis A , AnalysisDetail AD Where A.AnalysisId = AD.AnalysisId And A.PatientId = P.PatientId -- Get The Entered Result from user Select @Result = I.Result From Inserted I -- Get Min And Max Values from ItemRange Select @Min = MinValue , @Max = MaxValue From ItemRange , Inserted Where ItemRange.ItemInfoId = Inserted.ItemInfoId And ( ItemRange.Sex = @Sex Or ItemRange.Sex is NULL ) -- Set Normality If ( ( @Result >= @Min ) AND ( @Result <= @Max ) ) Set @Normality = 0 -- Normal else If ( @Result > @Max ) Set @Normality = 2 -- Max else -- If ( @Result < @Min ) Set @Normality = 1 -- Min -- Insert Data To AnalysisDetail Insert Into AnalysisDetail Select I.ItemInfoId , I.AnalysisId , I.Result , @Normality From Inserted I End ------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------ -- 3)) Add Data to Tables ------------------------------------------------------------------ Use MyDataBase Go
و لكن لا يتم بناءه و يعطيني رسالة خطأ و هي
Server: Msg 154, Level 15, State 1, Procedure Trigger_AnalysisDetail_Normailty, Line 67 a USE database statement is not allowed in a procedure or trigger.
كيف بدي حل المشكلة
شكرا لكم
سلام