You want to create a stored procedure that outputs productNo,productName and productPrice. You want to ensure that the definition of this procedure is not available to anyone who can query the system catalog.

Which of the following T-SQL statements can you use to accomplish this task?

Posted by Rajkatie on 6/24/2013 | Category: Sql Server Interview questions | Views: 5496 | Points: 40

Select from following answers:

CREATE PROCEDURE Getproduct WITH ENCRYPTION AS SET NOCOUNT ON; SELECT productNo, productName, productPrice FROM product
CREATE PROCEDURE Getproduct AS SET NOCOUNT ON; SELECT productName ,productNo, productPrice FROM product
CREATE PROCEDURE Getproduct with WITH ENCRYPTION AS SET NOCOUNT ON; SELECT productName ,productNo, productPrice FROM product
All Above