question

murphy avatar image
murphy asked

SQL View Update

I am working on one application which uses the below query and updates a column in dcEQUI table with a number (0,1,2,3 etc ).

SELECT WebEQTYPList.[Description] FROM dbo.dcEQUI

LEFT OUTER JOIN dbo.WebEQTYPList
ON dbo.dcEQUI.EQTYP = dbo.WebEQTYPList.EQTYP
WHERE(dbo.WebEQTYPList.EQTYP IS NULL) -- I would like to understand that how it is updating dcEQUI table when no key column from dcEQUI table is used in this view. This view is executing on OnValidate event of a page built on ASPNET .

Everytime when a record on the page is validated same view is being used to update the column at the backend dcEQUI table.

sql server 2012asp.net
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.