SQL Database Concepts Question: Download Questions PDF
Tell me the use of keyword WITH ENCRYPTION. Create a Store Procedure with Encryption?
Answer:
It is a way to convert the original text of the stored procedure into encrypted form. The stored procedure gets obfuscated and the output of this is not visible to
CREATE PROCEDURE Abc
WITH ENCRYPTION
AS
<< SELECT statement>>
GO
CREATE PROCEDURE Abc
WITH ENCRYPTION
AS
<< SELECT statement>>
GO
Download Basic SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How SSRS maintain security? | Do you know what is a linked server in SQL Server? |