If I create a stored procedure with encryption then I can not see the proc's definition either by using sp_helptext or by right clicking on the proc and generate the script.
Is there any way to generate the script for encrypted stored procedure?
If the answer is no, then while we give build for testing then we need to save the proc's definition in the hard disk and if that file is deleted from the hard disk there is no way to get the definition of proc (even if the deleted file is not recovered from any software).
So the encrypted procedure needs careful handling in terms of storage. Is my understanding correct?
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…