The Scary DBA

Blog Post

Thank You Andy!

I remember going into Andy Leonard’s session at PASS Summit in Denver. I’m not going to lie, it was kind of sparsely attended, so I got to sit up...

2022-08-02

9 reads

Blog Post

Thank You Tim!

Ah, Tim Ford. I remember the time we were sitting at Ruth Kriss Steakhouse trying to figure out which of the two of us was the dumbest person in...

2022-08-12 (first published: )

238 reads

Blog Post

Thank You Wendy!

I honestly don’t know when or how I met Wendy Pastrick, but I’m so happy I did. Wendy and I have been friends for a very long time. Thank...

2022-07-19

12 reads

Blog Post

Sabbatical!

Redgate Software has a policy wherein every 5 years, employees receive a 6-week paid sabbatical. Well, I’m up to year 11 (I skipped a year my first time), so...

2022-07-18

3 reads

Blogs

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Humble Bundle of Java Books

By

I try to keep an eye on the Humble Bundle bundles for books. The...

How Redgate’s Test Data Manager Can Enhance Automated Testing

By

A brief overview of the benefits and challenges of automated testing and how Redgate’s...

Read the latest Blogs

Forums

TSQL Pivot Crosstab

By Tallboy

Hi, I am doing a crosstab but I am unsure if its a pivot...

Filestream Filegroups on state RESTORING

By M@dboy

Hello All, I have a question. My SQL Servers are running SQL Server 2019...

Find dependencies on a table

By water490

I am in the process of doing a re-write for my project so I...

Visit the forum

Question of the Day

Updatable Views II

I have this view:

CREATE OR ALTER VIEW dbo.City 
AS
SELECT TOP 10 
 cn.CityNameID, cn.CityName
 FROM dbo.CityName AS cn
 WITH CHECK OPTION
GO
How can I modify the view to make it is updatable with this code?
INSERT City (CityName) VALUES ('Dillon')

See possible answers