Can anyone help I need to know if transactional SQL commands can be spread across SQL statements on seperate pages, the reason I ask is as follows:
I've built a website to take online appointments, to complete a booking data must be entered into four tables in the database, each table gets its data from a seperate form and the four forms are on seperate pages in the website. If someone fills in ,say, the first two forms but then leaves the site I want the data just entered in the two tables to be deleted. I think this is done with transactional SQL but all the examples I have seen have the BEGIN WORK , ... , COMMIT within one SQL statement!
Any ideas? All help would be much appreciated!
