Create Stored Procedure 1

[astrodestino]

Hi!
I made an aplication to create and manage sql server tables.
I use sintax like CREATE TABLE for example.
Is there any sintax like that to create a stored procedure?
Tnx!!

 

[amrita418]

You should look into books online for create procedure syntax and examples.

CREATE PROC [ EDURE ] [ owner. ] procedure_name [ ; number ]
[ { @parameter data_type }
[ VARYING ] [ = default ] [ OUTPUT ]
] [ ,...n ]

[ WITH
{ RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } ]

[ FOR REPLICATION ]

AS sql_statement [ ...n ]

Regards,
AA

 

[astrodestino]

tnx!