When you are working as a Developer that time everything is depends on situations.
Here i am describe how these both are diffrent.
SP- Stored Procedures are created once in database and you just execute it with exec , u can use very easily. If you want any changes in ur query in SP u can change in ur database.
Inline query- When we are using inline queries. What happend lets see an example, suppose u have a 10 web forms and u wright ur inline query in all ur 10 webforms, after sometimes u think, u have to change the query or add some more parameters on that query, that time what u do , u open all 10 webpages and open the code and change the query. If ur query is very large that time, its a big hedeche for u how to change it. If you have essential to use inline query, always store ur queries with StringBuilder because its faster than string and with the use of Append Method u can easily understand ur inline queries.
StringBuilder _strQuery = new StringBuilder();
_strQuery.Append("SELECT EMPLOYEENAME, EMAIL, ADDRESS");
Stored procedures are the best for the security resons, users can't access and see ur code of SP, but the use of SQL Injections anybody can see ur Inline query code.
If i am talking about execution, So Stored procedures are Executed fast, because In inline queries compilerfirst understand ur query than send it to sql compiler than it understands it and than it will be executed.
Inline queries are not easy to understand some times when they are large queries.
For any more sugestion u can mail me on email@example.comMurugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator