Stored procedure to search every field in the database for a string literal. Run the stored procedure in Query analyser, which will output sql statements to do the search. The output of these searches will be the update sql, which again should be pasted into a query analyser window. As the stored procedures do not […]
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 GOHow can I modify the view to make it is updatable with this code?
INSERT City (CityName) VALUES ('Dillon')See possible answers