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.

Dropping a view

Refresh all views in a database

Refresh all views in a database

The View Insert

Summed Views

The altered view

Looking at VIEWs, Close Up

Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how to determine if a view can be indexed or if it is updateable. Joe Celko takes a tricky topic and comes up with some helpful guidelines.