Must declare the scalar variable problem

Question

Dear all,

I keep having this message "Must declare the scalar variable "@dataCreated".

I hope someone can help me out. 

Thanks

There is the coding

Create TRIGGER checkNotMoreThanSixdayss On Booking
 AFTER INSERT, UPDATE, DELETE
 AS
 BEGIN
 
  DECLARE @dateCreated DATE,
 
  
  DECLARE @bookingInserted VARCHAR(6)

  SELECT @bookingInserted = bookingID
  FROM inserted;

  SELECT @dataCreated = dateCreated
  FROM Booking
  WHERE bookingID = @bookingInserted;

 IF DATEDIFF(dd, @dateCreated,)> 6            
     ROLLBACK TRANSACTION                           
  END

Answer 1

Dude, you didn't declare this variable. :)

you declared '@dateCreated' and are calling as '@dataCreated'...

Answer 2

Dude, you didn't declare this variable. :)

you declared '@dateCreated' and are calling as '@dataCreated'...

UP

---

More: blog.csdn.net/happyflystone

Answer 3

Dude, you didn't declare this variable. :)

you declared '@dateCreated' and are calling as '@dataCreated'...

Hi and thanks for replying.

But i thought i have declared it here?

  DECLARE @dateCreated DATE, @bookingDate DATE

strangely it works for @bookingdate..

thanks

Answer 4

Dear all... thanks for spotting the dumb mistake..

I placed dataCreated not dateCreated...

once again.. thanks alot..