Click here to Skip to main content
15,504,830 members
Home / Discussions / Database
   

Database

 
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 
Yes that's right, you keep the values you are inserting/updating/deleting then call a routine to record the changes in the ascii text audit file. Smile | :)

Re Getting data from the DB, I'm sorry but I don't know how to retrieve data from SQLServer from past transactions, I'm sure it's possible from the transaction log. But in my circumstances it's been easier to just store the old values and new values when they happen to variables then send to the ascii log file.
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 
AnswerRe: Excel, OleDb, ACE, and skipping header rows Pin
Jörgen Andersson17-May-12 12:39
professionalJörgen Andersson17-May-12 12:39 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
PIEBALDconsult17-May-12 15:20
professionalPIEBALDconsult17-May-12 15:20 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
Jörgen Andersson17-May-12 21:36
professionalJörgen Andersson17-May-12 21:36 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
PIEBALDconsult21-May-12 9:38
professionalPIEBALDconsult21-May-12 9:38 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
Jörgen Andersson21-May-12 10:59
professionalJörgen Andersson21-May-12 10:59 
QuestionSerial number in SQL Pin
draghu17-May-12 1:17
draghu17-May-12 1:17 
AnswerRe: Serial number in SQL Pin
Pablo Aliskevicius17-May-12 3:48
Pablo Aliskevicius17-May-12 3:48 
AnswerRe: Serial number in SQL Pin
Andy_L_J17-May-12 21:51
Andy_L_J17-May-12 21:51 
GeneralRe: Serial number in SQL Pin
draghu17-May-12 23:11
draghu17-May-12 23:11 
QuestionSybase DB access in windows 7 Pin
VenkataRamana.Gali16-May-12 18:29
VenkataRamana.Gali16-May-12 18:29 
AnswerRe: Sybase DB access in windows 7 Pin
JohnsonLuis16-May-12 22:07
JohnsonLuis16-May-12 22:07 

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.