CODEWITHSUNDEEP
c#asp.netsqlgetdate
Deviney
Deviney

Reputation: 131

MS SQL GETDATE() not working in SQL command

I am trying to update a record in my MS SQL database but cannot seem to get the GETDATE() function to work.

Will somebody look at the code below and tell me were am going wrong? 

BEGIN
    update Bookings
  set TotalBookings = TotalBookings+1
  set LastBooked = GETDATE()
  where PropertyId='1007' 
END

Upvotes: 0

Views: 632

Answers (1)

Habib
Habib

Reputation: 223187

Your syntax is wrong it should be:

BEGIN
  update Bookings
  set TotalBookings = TotalBookings+1 ,
      LastBooked = GETDATE()
  where PropertyId='1007' 
END

You are using set multiple times, instead use set once and separate your columns with comma.

For more info see: UPDATE (Transact-SQL)

Upvotes: 4

Related Questions