欢迎来到计算机考试题库网 考试题库官网
全部科目 > 计算机考试试题及答案解析

未知题型

Exhibit:
UPDATE EzonexamConsolidated
SET District = ‘Mexico’
WHERE RtvID = 45
You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.
When users run the query in the exhibit above the receive the following error message:
Server: Mrh3612, Level 16, Stats 1, Line 1
View or function ‘EzonexamConsolidated’ is not updateable because it
contains aggregates:
How should you enable the query to run?

    A.com.
    B.
    When
    C.Create
    D.
    B.The
    E.
    C.To
    F.
    D.On
    G.
【参考答案】

C
解析:Explanation:SQLServer2000usesINSTEADOFtriggersandpa...

(↓↓↓ 点击下方‘点击查看答案’看完整答案 ↓↓↓)

点击查看答案

相关考题