zaagan
8/3/2019 - 4:40 PM

MS SQL SP Syntax

MS SQL SP Syntax

MS SQL SP Syntax.sql
content_copyfile_download
[CREATE|ALTER]  [PROC|PROCEDURE]
    [schema_name.]procedure_name [@parameter data_type] 
    [NULL|NOT NULL ] [ = default ] 
    [OUT|OUTPUT| [READONLY]]
  [WITH {procedure_option}, ...]
  [FOR REPLICATION]
AS
[BEGIN]
  sql_statement;
[END]