Unlocking Power with Updatable Views in SQL Server

An updatable view in SQL Server is a view that allows modifications such as INSERT, UPDATE, or DELETE operations on the underlying tables through the view.

Updatable Views II

An Updatable View

Views in SQL Server 2019 with SSMS

This article explores how to create and use views in SQL Server 2019 using SSMS.

Understanding Views in SQL

Learn about the concept of views in SQL, and how they work. Read on to see clear examples of how to implement views.

A Strange View

Insert and Delete SQL Server Data with Views

In this tip we look at how to insert and delete data via SQL Server views.

Generate views to correct the column collation on a target DB's tables automatically

You find you are querying a vendor supported database where you're not allowed to make any collation changes, and which has a weird collation setup: default DB collation that matches your server and other databases all character related columns are explicitly a different collation that does not match your DB or server collation Rather than […]

SQL Server Trigger on View Example

In this tip we look at how to create a SQL Server trigger on a SQL Server view.

Rebuild or recompile all views

Simple script to refresh or recompile your business-level views.