Home Forums SQL Server 2005 Administering TEMPORARY TABLES AND DATABASES IN SQL SERVER 2005 RE: TEMPORARY TABLES AND DATABASES IN SQL SERVER 2005

  • Dear Lowell Sir,

    Actually, i have a .net application through which lacs of data would be inserted by the users.

    but as usual, users keep on making mistakes. so i want that at the back end of the application,when the users enter the data, then the data is entered into a temporary table, and after the user presses the last save button, then the whole data is committed to the main original table.

    also, the users delete the data by mistake, which would be very dangerous.

    so i want that if a user deletes the data by mistake, then it is deleted from only the temporary table and not from the original table. that is why i need the users to alter, delete and insert in the temporary table, and when the final button is pressed then the data is committed to the original table.