Database

yousefshokati wrote:

can a trigger have parameters?

yousefshokati wrote:

I am designing a query . I want to write a query that accepts parameters. Is
this possible how?
and if not what should I do to solve this

CREATE PROCEDURE updateBalace 
@personnelCode int--could be other datatype
@amount decimal--could be real, money or whatever
AS

SET @actionAmount decimal=100.00

BEGIN TRAN
   UPDATE Personnel SET Balance=Balance+Amount WHERE PersonnelCode=@personnelCode

   IF EXISTS(SELECT Balance FROM Personnel WHERE Balance>@actionAmount AND
             PersonnelCode=@personnelCode)--Check if updated record exceeds certain balance
   BEGIN
      --Insert record into turnsTable and play some funky music :) 

   END

--check for errors
IF @@ERROR >0 
  ROLLBACK TRAN
ELSE
  COMMIT TRAN

SilimSayo wrote:

--Insert record into turnsTable and play some funky music

Gali1978 wrote:

and if the database is in work - it will be a problem

yousefshokati wrote:

can i omit the foreign key constraint in this design without loosing the normal form of my database ?

Bastard Programmer from Hell