What is the meaning of "stored procedures precompiled"?

Question

I often heard people say that stored procedures are precompiled. What does it mean?

Actually, we write requests to the stored proc and compile them. If there is any syntax error, she complains. So, if this is the case, then compilation takes place at this point in time.

Then what does "Pre" mean?

Answer 1

They are actually pre-parsed, and the syntax / semantics are checked for CREATE and ALTER

"Compilation" to the query plan is performed on request

. " , SQL Server 2005"

( , ) SQL Server 6.5. "" , , SQL Server 7.0

Answer 2

Microsoft SQL Server .

, . " ".

, sp_recompile .

Answer 3

The contents of the sql stored procedure will not be parsed if you run it. Parsing sql can take a very long time.