Updating multiple tables sql server
Unlike stored procedures (which also support parameters), these parameterized functions can be updateable, as you'll see later in this chapter.
In the case where the application server and database server are on different hosts, the round-trip will involve network latency as well.The triggers in views are covered later in this chapter.Another limitation of views that you may be familiar with is that a view cannot be indexed. In SQL Server 2000, you can indeed create indexed views, as shown later in this chapter.Views can be used in place of tables in your Access front-end application, whether you're using an Access database or an Access project.Views can also reference functions and other views.
Search for updating multiple tables sql server:
Similar performance benefits can be gained with SQL Server by basing your reports on views. A simple solution to the issue of implementing row-level and column-level security is to revoke all permissions to the underlying tables.