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.
2020-06-30
Views
2020-04-20
800 reads
Insert and Delete SQL Server Data with Views
In this tip we look at how to insert and delete data via SQL Server views.
2020-01-13
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 […]
2019-07-05 (first published: 2019-06-26)
438 reads
SQL Server Trigger on View Example
In this tip we look at how to create a SQL Server trigger on a SQL Server view.
2019-05-01
2017-10-05 (first published: 2017-10-02)
4,876 reads
2016-11-11
1,336 reads
2016-10-28 (first published: 2016-10-05)
8,393 reads
2016-07-14
1,426 reads
2016-06-27
1,356 reads
Blogs
What Agent Jobs are Running??
By gbargsley
Do you run SQL Agent Jobs in your environment? Do you know what is...
Unboxing SQL Clone 2020 for a PoC
By Steve Jones
When I got a new machine, I had SQL Clone on my old machine,...
Daily Coping 4 Aug 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Secondary replica is down at moment
Hi Team , We have three node cluster setup where the one primary server...
SQL 2016 vs SQL 2008R2 float to numeric Difference:
Hi, we are upgrading from SQL server 2008 R2 to SQL server 2016 between...
Extended Events
I have set up an extended event to capture the queries users may be...
Ask SSC