What is the syntax to write Stored Procedure in SQL requiring parameter values from user?
Syntax for Writing Stored Procedure with Parameters
Collapse
X
-
1) Creating a Stored Procedure
Create Procedure <Procedure Name>
(<Parameter1> DataType, <Parameter1> Datatype......)
As
Begin
--your t-sql statements
End
--------------------------------------------------------------------------------------
2) Executing the stored procedure
Exec <Procedure Name> Parameter1, parameter1,.... ...Comment
Comment