StoredProcedure is fater than any queries. Since it is the Pre-Compiled one. But in case of queries (static/Dynamic) needs to be compilled once b4 they get ready for execution

hi ,

I think procedure is faster than parametrized query because procedure is precompiled statement.

Which is more faster parameterized query or stored procedure? Want detailed explanation of it.