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
806 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)
457 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)
5,560 reads
2016-11-11
1,336 reads
2016-10-28 (first published: 2016-10-05)
9,504 reads
2016-07-14
1,426 reads
2016-06-27
1,356 reads
Blogs
Daily Coping 27 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
How do I test if a linked server works using T-SQL?
I get that linked servers are almost as despised as the dreaded cursor or...
Power BI Monthly Digest – October 2020
By Devin-Knight
In this month’s Power BI Digest Matt and I will again guide you through...
Forums
identify sql backup strategies
how do I identify if the dbs are getting backed up (full,diff,log) without looking...
what does it mean for the following SQL Scripts
in a stored procedure, I found two line sql scripts " if @@microsoftversion > 0x07320000 exec sp_MSreplraiserror 20598...
Ask SSC