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: 4910 | Points: 40
Select from following answers:
  1. CREATE PROCEDURE Getproduct WITH ENCRYPTION AS SET NOCOUNT ON; SELECT productNo, productName, productPrice FROM product
  2. CREATE PROCEDURE Getproduct AS SET NOCOUNT ON; SELECT productName ,productNo, productPrice FROM product
  3. CREATE PROCEDURE Getproduct with WITH ENCRYPTION AS SET NOCOUNT ON; SELECT productName ,productNo, productPrice FROM product
  4. All Above

Show Correct Answer


Asked In: measureup.com | Alert Moderator 

Comments or Responses

Login to post response