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
What do you know about system database?
What are constraints in Microsoft SQL Server?
What is default constraint in MS SQL Server?
Explain the steps to use Transact-SQL Cursor?
What is cursor in MS SQL Server?
Do you know the cursor optimization tips?
Do you know the cursor types?
What is Implicit cursors?
What is Key set driven?
What is Forward – only cursors / Read only cursor?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
