If you are creating a stored procedure and you want to make sure that the procedure definition cannot be viewed by other users , you can use the with encryption clause 如果要创建存储过程,并且希望确保其他用户无法查看该过程的定义,则可以使用with encryption子句。
If a previous procedure definition was created using with encryption or with recompile , these options are enabled only if they are included in alter procedure 如果原来的过程定义是使用with encryption或with recompile创建的,那么只有在alter procedure中也包含这些选项时,这些选项才有效。
Set options , such as quoted identifier and ansi nulls , are persisted with stored procedure definition and , therefore , take precedence over different values explicitly set for them Set选项(例如, quoted _ identifier和ansi _ nulls )与存储过程定义保留在一起,因此它优先于显式为其设置的其他值。
If you replicate the execution of a stored procedure , the procedure definition is replicated to the subscriber when the subscription is initialized ; when the procedure is executed at the publisher , replication executes the corresponding procedure at the subscriber 如果复制存储过程的执行,则在初始化订阅时,会将过程定义复制到订阅服务器;当在发布服务器上执行该过程时,复制将在订阅服务器上执行相应的过程。