Role Of Jewelery And Costmetic Use In Interview

To create an encrypted stored procedure in SQL Server we use the WITH ENCRYPTION Must intruccion CREATE or ALTER statement after

CREATE PROCEDURE procedurename
/ *
(
@ parameter1 int = 5, @ parameter2 datatype
OUTPUT
)
* /

WITH ENCRYPTION AS SELECT * FROM
Table
RETURN

Because We Must Be carefull in theory at least, it's not possible to decrypt it.