why store proc says like pre- compiled.?

Question

Sundar · Answer

When you create or update a stored procedure on the server it gets a syntax check. But there is no compile process let alone a pre-compile process. That stored procedure exists exactly as it is named a procedure that is stored on the server. It’s just a collection of TSQL code possibly with some parameters waiting to be called. Until it’s called it is not ready to be executed.

Naveen Bisht · Answer

it gets a syntax check. But there is no compile process thanks for same