difference between procedure and stored procedure sql server?

Question

What is the difference between a procedure and a stored procedure on sql server?

Answer 1

If it's an actual procedure, in the database, it's a stored procedure -- regardless of whether people pronounce the "stored" part.

Stored procedures are in opposition to the client's issuing the SQL statements of the procedure one by one. That's what an un-"stored procedure" would be.

Answer 2

There is no difference.

CREATE PROCEDURE

Will create a stored procedure

select * from sys.procedures

will show you the stored procedures.

This is as opposed to sending adhoc sql statements or prepared sql statements.