T-SQL Options ( Microsoft SQL Server) [closed]
Why can't I use the RECOMPILE option along with FOR REPLICATION when creating stored procedures?
MSDN explicitly states
FOR REPLICATION
Specifies that stored procedures created for replication cannot be executed on the Subscriber. A stored procedure created with the FOR REPLICATION option is used as a stored procedure filter and only executed during replication. This option cannot be used with the WITH RECOMPILE option.
Why they choose not to allow this is beyond me.
加载中,请稍侯......
精彩评论