Joyful Crafsmen is a young company designing, constructing and operating business intelligence solutions for enterprises. People behind are experts in Microsoft Data Platform, which includes SQL Server, Microsoft Azure, Power BI and other leading edge Microsoft technologies. Sharing our know-how with others is our other love. Through training, consulting, and teaching in our community, we help others to be better and better every day.

Blog Post

Microsoft Fabric

What will be much easier with Microsoft Fabric?
Microsoft Fabric is built on a foundation of Software as a Service (SaaS), which takes simplicity and integration to a whole new...

2023-07-24 (first published: )

383 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

DBCC CheckDB errors

By mtz676

How can I identify automatically(like email alert if error shows up) through code if...

Optional feature error

By GeorgeMayes

I have installed SQL Server Reporting Services 2019 on my Windows 10 machine, and...

SCOM alerts

By ramana3327

Hi, We are receiving alerts from SCOM regarding WMI health has errors. MP has...

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