Q. Type of procedure that are based on the CLR (Common Language Runtime) is ____________

View solution

Q. Nesting limit OF stored procedure is up to ________level.

View solution

Q. User defined function in SQL Server can return ____________

View solution

Q. Point out the wrong statement.

View solution

Q. Function cannot be used for __________ statement.

View solution

Q. The benefit of using user-defined functions in SQL Server are ____________

View solution

Q. Point out the wrong statement.

View solution

Q. Syntax for creation of user defined function is ____________

View solution

Q. How many types of user defined function is provided by SQL Server?

View solution

Q. Which of the following is not a User defined function?

View solution

Q. Which of the following does not return a table variable?

View solution

Q. User defined scalar function can return only __________ data type values.

View solution

Q. Which of the following is not a limitation of user defined function?

View solution

Q. Point out the correct statement.

View solution

Q. Which of the following statements cannot be included in the definition of a Transact-SQL user-defined function?

View solution

Q. CREATE FUNCTION requires __________ permission in the database.

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following is the most visible benefit of user-defined function?

View solution

Q. UDFs in SQL Server is composed of _______ parts.

View solution

Q. When to choose scalar function over inline table valued function?

View solution