Should I use query or stored procedure to get results fast.
Your question is very unspecific. Usually the majority of the query time will be returning large volumes of data.
Having a stored procedure is usefull for complex data retrieval or if you want to perform other actions such as logging and for having a precompiled query execution plan.
Personally I prefer to just wrap up my report query in a view to keep the logic out of the report and to make updates via SQL.
I see no harm in using a stored proc though.
|||Stored Procedures are best.Check out this Link
http://www.sql-server-performance.com/stored_procedures.asp
Regards
Raj Deep.A
No comments:
Post a Comment