Updating multiple tables in sql server 2016

If you get an error, either the view is not logically updatable, or the query processor can't tell that it is.How do create a stored Procedure Help converting a cursor to a set based query How many stored procedure can I call from the same store procedure ? sql datetime field format Easy way to manage full database name in stored procedures and triggers?please one of the interviewer asked me dynamic SQL help needed How To Create A Cursor That Uses Dynamic SQL? The plan shown will also show you how much of the view definition the query optimizer was able to remove (because it is redundant). Requesting a "estimated" plan does not involve executing the query, naturally.

From an update perspective, it would be more efficient to store the SSN in one table then reference that table from the 70 others. Since that ship has undoubtedly sailed, you might write a stored procedure that updates the 70 tables. From an update perspective, it would be more efficient to store the SSN in one table then reference that table from the 70 others. Since that ship has undoubtedly sailed, you might write a stored procedure that updates the 70 tables.

Write it so you pass in the old SSN and the new SSN then it updates the 70 tables accordingly. Write it so you pass in the old SSN and the new SSN then it updates the 70 tables accordingly.

A very tedious task to update over 70 tables with ssn columns one by one.

Does anyone have an idea how to do this efficiently ?

Occasionally, I get calls for a customer who entered their ssn wrongly the first time they registered on the our website.when I get such a request, I manually update all the ssn in every database table that stored information about the customer.

terrem43.ru

36 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>