stored procedure for all tables

Question

hi everyone please help me I want to update data field Status on All table in a database with stored procedure. so when I click button Lock. field status on a table change Y but before change data in all tables automatic was copy data. are you understand? sorry for my bad english.

Mega Anaska · Answer

thanks:)

Joginder Banger · Answer

HI Mega Happy Holi.. I confused you want every time take backup table data before update table or special time like above you want. if you want backup every updating time then should be used the trigger for more about the trigger hit this link ... http://www.dotnet-tricks.com/Tutorial/sqlserver/OPUH170312-After-Trigger-Instead-of-Trigger-Example.html before going to second option i want ask you what is ways to backup like a copy all in a particular in table or make script??????? Update column value all database tables check this link http://stackoverflow.com/questions/25780297/how-to-update-all-tables-with-a-particular-column-name thanks JSB

Manas Mohapatra · Answer

You need to write simple update statement to update Status column. Where did you stuck?