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.
2024-04-22
5,504 reads
Views
2024-08-05 (first published: 2024-02-26)
542 reads
2024-02-12
498 reads
Views in SQL Server 2019 with SSMS
This article explores how to create and use views in SQL Server 2019 using SSMS.
2021-12-27
6,922 reads
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
2020-04-20
869 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)
4,336 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)
15,791 reads
Blogs
Build a C++ Pipeline with Docker, GitHub Actions, Azure ACR and Azure App Service
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
Better Trigger Design: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
SQL Server in the Cloud – Are DBAs Still Needed?
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
Forums
Getting year part out of a string that represents a date
Hi, I have a requirement to fetch the year from an imported .csv file...
Dropping a PK constraint.
I will have to test this next week, but will not have a chance...
SQL - Conditional merge join
I want to add a condition in the joining columns part of the merge...
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers