Wednesday, March 21, 2012

differnce between stored Procedure and stored Functions?

Hi all,
What is the Difference between Stored Procedure and Inline Quries..... Is Stored Procedure is faster then Inline Query...
What is the professional Approch...
I m using Inline Quries in my Professional Project with Microsoft Application Block.... Someone Said me this is not a professional approch... use stored procedure instead of Inline Quries... i m so puzzled...
plz guide me.... :)
Thanx
Sajjadwhat is the differnce between stored Procedure and stored Functions ????|||please check first in any search engine.|||Functions are easier to fold into SELECT statements, as they return scalar or table values.
Stored procedures have fewer programming limitations than user-defined functions, but must be run independently and not as part of a select statement.sql

No comments:

Post a Comment