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,133 reads
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,133 reads
2024-08-05 (first published: 2024-02-26)
541 reads
2024-02-12
495 reads
This article explores how to create and use views in SQL Server 2019 using SSMS.
2021-12-27
6,702 reads
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
868 reads
In this tip we look at how to insert and delete data via SQL Server views.
2020-01-13
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,272 reads
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,308 reads
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
Wonderful afternoon every person, it's season towards dive again into the mailbag and resolution...
Comments posted to this topic are about the item Limits, Not Goals
MS SQL Server/SSMS are my tools. As my project evolves I find I need...
What is the precision, length, and scale for an int variable?
See possible answers