I'm NOT a SQL guy...
So need code for a sql trigger...
TableA
ID, NAME, PASSWORD
TableUpdate
ID, NAME, PASSWORD, METHOD
Once TableA UPDATE, insert to TableUpdate
ID, NAME, PASSWORD, "UPDATE(String)"
Once TableA INSERT, insert to TableUpdate
ID, NAME, PASSWORD, "INSERT(STRING)"
Once TableA DELETE insert to TableUpdate
ID, NAME, PASSWORD, "DELETE(String)"
please start comment with SQL18
"SQL18"
As an expert in SQL, i am very much interested to do this work. I have a question, you want to have "UPDATE(String)" when an update occurs, here String means ?
Thanks
sql 18. Hello I am an expert developer and an IT engineer. I know you do not prefer mysql. I can help you in trigger, I am an database expert who can deliver optimal solutions to complex problems. thanks.
I have more then 10 years of experiance in sql server. Consider me for the job. Hope to hear from you. Work is done. Can deliver you in 5 minutes maximum. Waiting for a positive response.