You can also view and update the data contained in tables and views, and execute stored procedures and functions.
还可以查看并更新表和视图中所包含的数据,并执行存储过程和函数。
From a data-persistence standpoint, the fastest way to perform a database update operation is to use local transactions combined with database stored procedures.
从数据持久化的角度看,进行数据库更新操作的最快速的方式是将本地事务与数据库存储过程一起使用。
The opposite operations can either be restricted or can be done using similar stored procedures (update in the relational column updates the XML document too).
也可以使用类似的存储过程限制或执行相反的操作(更新关系列导致同时更新XML文档)。
SQL stored procedures are provided to retrieve and update these policies. Using the stored procedures, you can perform the following tasks.
可以使用SQL存储过程来检索和更新这些策略。
Is it better to create stored procedures for any required operations on a table in the database (e. g. create and read on this table, update and delete only on another one,...)?
这是更好地创建所需的任何操作在一个数据库中的表的存储过程(例如创建和读取此表,更新和删除只有一个,……)?
For example, you must update any stored procedures that reference a table column that you have renamed.
例如,如果重命名表中的一列,则必须更新引用该列的所有存储过程。
Finally, you can override the default update behavior when the database requires table access through stored procedures.
最后,在资料库需要透过预存程序进行资料表存取时,也可以覆写预设更新行为。
Finally, you can override the default update behavior when the database requires table access through stored procedures.
最后,在资料库需要透过预存程序进行资料表存取时,也可以覆写预设更新行为。
应用推荐