Câu 31: 70-464: Developing Microsoft SQL Server 2012/2014 Databases
You need to encapsulate a T-SQL script into a reusable user-defined object. The object must meet the following requirements: ✑ Permit insertions into a table variable. ✑ Support structured exception handling. ✑ Prevent changes to the definition of referenced objects. ✑ Support the use of the APPLY operator on the outp…
Nội dung câu hỏi
You need to encapsulate a T-SQL script into a reusable user-defined object. The object must meet the following requirements: ✑ Permit insertions into a table variable. ✑ Support structured exception handling. ✑ Prevent changes to the definition of referenced objects. ✑ Support the use of the APPLY operator on the output of the object. Which type of object should you use?
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 inline table-valued function
- B. A stored procedure
- C. A scalar user-defined function — đáp án hiện tại
- D. A multi-statement table-valued function
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.