Danny Riebeek

  • Interests: SQL Monitoring

Blog Post

SQLTreeo SSMS Add-In guide

SQLTreeo Add-In   plugin for SQL Server Management Studio   Version Applies to SQLTreeo Add-In version 0.8.7 or higher.     Purpose Informational guide on how to use the...

2019-02-25

94 reads

Blog Post

SQLTreeo Add-In guide

SQLTreeo Add-In   Plugin for SQL Server Management Studio   Version Applies to SQLTreeo Add-In version 0.8.7 or higher.   Purpose Informational guide...

2019-02-19

246 reads

Blog Post

SQLTreeo Add-In guide

SQLTreeo Add-In   Plugin for SQL Server Management Studio   Version Applies to SQLTreeo Add-In version 0.8.7 or higher.   Purpose Informational guide on how to use the SQLTreeo...

2019-02-19

61 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

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...

Career Advice

By sqlenthu 89358

hello folks, I am posting this question with heavy heart. I have been a...

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