I am new to Stored Procedures and I need some help please.
I am trying to create a stored procedure that would
change sensitive data of multiple tables to privatize
then for testing and developing purposes.
Basically for a given table say: Students I'll have
another table PrivateStudents that will have the same
columns as students plus a reference to Students primary
I create a Cursor for Students and go through all rows.
For each row I have a second cursor that selects the
record in PrivateStudents with the current Students
Primary key number.
Then I update Students with ...