I've scoured msdn and haven't found an answer. Is there a difference I should know about?
If there is truly no difference then why would this redundancy exist?
--SQL Server Stored Procedure Syntax
CREATE { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ]
[ { @parameter [ type_schema_name. ] data_type }
[ VARYING ] [ = default ] [ OUT | OUTPUT | [READONLY]
] [ ,...n ]
[ WITH <procedure_option> [ ,...n ] ]
[ FOR REPLICATION ]
AS { [ BEGIN ] sql_statement [;] [ ...n ] [ END ] }
[;]
Same with DROP PROC
DROP { PROC | PROCEDURE } { [ schema_name. ] procedure } [ ,...n ]
There is no difference between the two.
Edit to answer your new question - there is no "redundancy" here, one is just short hand for the other. "Procedure" is a fairly long word, and people tend to like shortcuts for things. In the same way, "Exec" and "Execute" are the same.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With