Why is stored procedure is better than executing a sql query. What is meant by exeution plan
AmrMohammed 0 Junior Poster
Alberto Bucur 0 Junior Poster
Read these:
http://www.techrepublic.com/article/determine-when-to-use-stored-procedures-vs-sql-in-the-code/
http://stackoverflow.com/questions/22907/which-is-better-ad-hoc-queries-or-stored-procedures
http://searchsqlserver.techtarget.com/tip/Stored-procedures-vs-dynamic-SQL-When-should-you-use-each
There are many others article on internet which debate this problem.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.