Madhu V

Madhu V

  • NA
  • 21
  • 3.3k

Which is the correct syntax for Stored procedure in SQL server ?

Nov 8 2022 2:47 PM
which one is correct ??? 1. CREATE PROCEDURE procedure_name AS sql_statement GO; OR 2. CREATE PROCEDURE [schema_name].procedure_name @parameter_name data_type, .... parameter_name data_type AS BEGIN -- SQL statements -- SELECT, INSERT, UPDATE, or DELETE statement END

Answers (5)