Синтаксис оператора CREATE PROCEDURE имеет вид:
(Отметьте один правильный вариант ответа.)
Варианты ответа
CREATE PROC [ EDURE ] procedure_name [ ; number ] [ { @parameter data_type } [ VARYING ] [ = default ] [ OUTPUT ] ] [ ,...n ] [ WITH { RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } ] [ FOR REPLICATION ] AS sql_statement [ ...n ](Верный ответ)
CREATE PROC [ EDURE ] procedure_name [ ; number ] [ { @parameter data_type } [ VARYING ] [ = default ] [ OUTPUT ] ] [ ,...n ] { WITH { RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } }{ FOR REPLICATION }[ AS sql_statement [ ...n ] ]
CREATE PROC [ EDURE ] procedure_name [ ; number ] [ { @parameter data_type } [ VARYING ] [ = default ] [ OUTPUT ] ] [ ,...n ] [ WITH { RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } ] { FOR REPLICATION }