Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices

VIEWs are an undervalued and underused feature in SQL. They basically consist of a query that has been given a name, and a parameter list, so can be used like an inline macro. Technically, you’re supposed to think of it as a virtual table.

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.