i want to write trigger in sqlserver 2008 . how to write
and i want a trigger for a table such that
Write a stored procedure in PL/SQL that accepts the registration number of a vehicle and determines if the vehicle is available. The answer can be 'True' or 'False' and should be returned as a parameter.
(ii) The value of the car_returned field of the Hire table can be 'True' or 'False'.
Write a trigger in PL/SQL that updates the Vehicle table with the current location of the car when the car is returned and the car_returned field is changed to 'True'.