Michael Lato


SQLServerCentral Article

Practical Methods: Naming Conventions

Everyone should establish some sort of naming convention for their SQL Server platform. It helps to ensure that developers and DBAs can easily find objects and communicate with one another. New author Michael Lato brings us the start of a series on organizing your SQL Server code with an article on naming conventions.

2.62 (13)

You rated this post out of 5. Change rating

2008-02-29 (first published: )

14,798 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