Monday, March 12, 2012

Hep needed!

Hi plz read below is my scenario
I have two diff tables which stores passwords (don't ask why b'coz it was there).Now to make data in both table consistance what I need to do?plz provide optimized solution.
Thanks in advance.
bye bye.
happy coding!!!
I have two diff tables which stores passwords (don't ask why b'coz it was there).Now to make data in both table consistance what I need to do?plz provide optimized solution.
Since there does not appear to be much detail in your statement, I am assuming that you are asking how you can keep passwords in both tables synchronised.
I would recommend that you create one stored procedure to update passwords and revoke explicit update statements to both tables. Then grant update to the stored procedure which will force everyone update to go thru that. Then you can update both tables in that sp.
hth

No comments:

Post a Comment