Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mavericky
Posting Yak Master
117 Posts |
 Posted - 2012-02-15 : 21:01:55
|
| Hi,I have a question in general related to database. In my database, there are about 70 tables. Now I want to implement delete functionality from the UI side. When a user deletes a record I want the record to stay saved in the database but not be seen on the UI. Can you tell me what approach should i use from the database side?Thanks,Mavericky |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-02-15 : 21:10:03
|
there isn't a function in SQL Server that is able to do it.Add a active flag column to your table. Default to TRUE, when user deletes a record, set the active flag to FALSE.In your select query, include active flag = TRUE to the where clause
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Delete functionality