Câu 64: 70-761: Querying Data with Transact-SQL
You need to create a database object that meets the following requirements: ✑ accepts a product identifies as input ✑ calculates the total quantity of a specific product, including quantity on hand and quantity on order ✑ caches and reuses execution plan ✑ returns a value ✑ can be called from within a SELECT statement…
Nội dung câu hỏi
You need to create a database object that meets the following requirements: ✑ accepts a product identifies as input ✑ calculates the total quantity of a specific product, including quantity on hand and quantity on order ✑ caches and reuses execution plan ✑ returns a value ✑ can be called from within a SELECT statement ✑ can be used in a JOIN clauseWhat should you create?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. an extended stored procedure
- B. a user-defined table-valued function — đáp án hiện tại
- C. a user-defined stored procedure that has an OUTPUT parameter
- D. a memory-optimized table that has updated statistics
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.