You have a database that stores information for a shipping company. You create a table named Customers by
running the following Transact-SQL statement. (Line numbers are included for reference only.)
You need to ensure that salespeople can view data only for the customers that are assigned to them.
Which Transact-SQL segment should you insert at line 07?
A.
RETURNS varchar(20)WITH Schemabinding
B.
RETURNS dbo.CustomersORDER BY @salesPerson
C.
RETURNS tableORDER BY @salesPerson
D.
RETURNS tableWITH Schemabinding
Explanation:
The return value can either be a scalar (single) value or a table.
SELECT 1 just selects a 1 for every row, of course. What it’s used for in this case is testing whether any rows
exist that match the criteria: if a row exists that matches the WHERE clause, then it returns 1, otherwise it
returns nothing.
Specify the WITH SCHEMABINDING clause when you are creating the function. This ensures that the objects
referenced in the function definition cannot be modified unless the function is also modified.
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-function-transact-sql