Click here to Skip to main content
15,564,467 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen22-May-12 1:52
professionalEddy Vluggen22-May-12 1:52 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201122-May-12 4:22
jojoba201122-May-12 4:22 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen22-May-12 9:50
professionalEddy Vluggen22-May-12 9:50 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201123-May-12 0:24
jojoba201123-May-12 0:24 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen23-May-12 1:16
professionalEddy Vluggen23-May-12 1:16 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201123-May-12 4:37
jojoba201123-May-12 4:37 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen23-May-12 9:23
professionalEddy Vluggen23-May-12 9:23 
AnswerRe: How to get delete/Update row + SQL Pin
Mycroft Holmes20-May-12 13:55
professionalMycroft Holmes20-May-12 13:55 
As Eddy has said, you need to address your requirements first! Attempting to retain every change, both from and to via the .ldf is not going to work. Eddies suggestion that you make copies of records instead of updating is valid (I have used this under duress), marking deleted records as Disabled is also a recognised solution.

Go back to your requirements and reassess them in the light of what you have learned over the last few weeks trying to use the wrong design to achieve a desired result.
Never underestimate the power of human stupidity
RAH

AnswerRe: How to get delete/Update row + SQL Pin
Corporal Agarn21-May-12 1:49
professionalCorporal Agarn21-May-12 1:49 
GeneralRe: How to get delete/Update row + SQL Pin
Eddy Vluggen21-May-12 4:45
professionalEddy Vluggen21-May-12 4:45 
GeneralRe: How to get delete/Update row + SQL Pin
Corporal Agarn21-May-12 4:51
professionalCorporal Agarn21-May-12 4:51 
GeneralRe: How to get delete/Update row + SQL Pin
Eddy Vluggen21-May-12 5:27
professionalEddy Vluggen21-May-12 5:27 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 14:04
JohnPayton21-May-12 14:04 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 21:08
jojoba201121-May-12 21:08 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 21:25
JohnPayton21-May-12 21:25 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 21:34
jojoba201121-May-12 21:34 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 21:51
JohnPayton21-May-12 21:51 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 22:22
jojoba201121-May-12 22:22 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton22-May-12 13:52
JohnPayton22-May-12 13:52 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201122-May-12 18:58
jojoba201122-May-12 18:58 
Questiondata base system Pin
sajid ali laghari18-May-12 21:30
sajid ali laghari18-May-12 21:30 
AnswerRe: data base system Pin
Eddy Vluggen19-May-12 1:39
professionalEddy Vluggen19-May-12 1:39 
QuestionHow to sort result if data fields contains both numeric and character value Pin
Rupesh Kumar Swami17-May-12 22:20
Rupesh Kumar Swami17-May-12 22:20 
AnswerRe: How to sort result if data fields contains both numeric and character value Pin
Eddy Vluggen19-May-12 1:32
professionalEddy Vluggen19-May-12 1:32 
QuestionExcel, OleDb, ACE, and skipping header rows Pin
PIEBALDconsult17-May-12 11:46
professionalPIEBALDconsult17-May-12 11:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.