Hellp there
I need to know how to store the result of a select statment into a variable. Is this even possible?
Here is the code I'm trying to work with.
Declare @LastResNumber as varchar(8)
Set @LastResNumber = Select max(ReservationNum) from Booking
ReservationNum is also varchar(8)
I need to know how to store the result of a select statment into a variable. Is this even possible?
Here is the code I'm trying to work with.
Declare @LastResNumber as varchar(8)
Set @LastResNumber = Select max(ReservationNum) from Booking
ReservationNum is also varchar(8)