RE: TEMPORARY TABLES AND DATABASES IN SQL SERVER 2005

SSC Guru

Points: 323504

February 10, 2011 at 7:42 am

while you were posting, i edited and added this:

as for deleting data...you can do the following: instead of REALLY deleting, you can add a column "isDeleted" to your data...then you can make the .net application select values WHERE isDeleted = 0 , and have the .net UPDATE that field to mark the row as isDeleted=1, instead of really deleting it...that makes it very easy to add an interface to "undelete" records that should not be deleted/need to be recovered.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!