Avi Niv is a senior consultant at Madeira. He is an expert in SQL Server administration and development. He has over 8 years of experience with SQL Server as well as with system infrastructures and with development projects.

Blog Post

Mind the Gap

Recently we deployed database mirroring in an environment with an Active Directory. The process is usually quite simple and straight-forward,...

2014-03-04

595 reads

Blog Post

Memory Timeouts

Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.
The timeouts seemed to...

2013-12-30

1,255 reads

Blogs

A New Word: Proluctance

By

proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

10 reasons why IT certifications are still important

By

As someone who has spent over 20 years in the Software/Data Engineering area and...

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Read the latest Blogs

Forums

Meet Claude, the new AI

By Daniel Calbimonte

Comments posted to this topic are about the item Meet Claude, the new AI

Updatable Views II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Updatable Views II

The Dangers of Not Upgrading

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Dangers of Not Upgrading

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