Post reply

instead of triggers

  • March 24, 2013 at 8:25 am

    #272139

    I came across this example regarding instead of triggers

    CREATE OR REPLACE VIEW dept_employees AS

    SELECT dname, ename

    FROM emp, dept

    WHERE dept.deptno = emp.deptno

    /

    Now there they explained that

    "Normally this view would not be updatable, because the primary key of the

    department (dept) table (deptno) is not unique in the result set of the

    join view. "

    Can someone please explain as to what this statement tries to convey?

  • March 24, 2013 at 8:31 am

    #1600110

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1434671-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply