Updating multiple fields in sql

Note that for example some databases such as Oracle, Postgre SQL, MS SQL Server , SQLite will allow you to update even a complex view by using an instead of trigger or rule against the view.

So although the function always outputs the same number of fields, you can selectively use only some similar to what you can do with views.Stored procedures are one of numerous mechanisms of encapsulating database logic in the database.They are similar to regular programming language procedures in that they take arguments, do something, and sometimes return results and sometimes even change the values of the arguments they take when arguments are declared as output parameters.Makes me wonder if these people have ever worked with modern databases.Stored procedures are one of the oldest methods of encapsulating database logic, but they are not the only method available.

Leave a Reply