Last post Mar 09, 2016 04:55 PM by amithashenoy
Member
59 Points
197 Posts
Mar 08, 2016 09:26 PM|amithashenoy|LINK
Hi,,
I want to retrieve data from table based on user input .What is the best way to do it just write Select query on table or write stored procedure.
Does it matter how much records v r retrieving in both methods ?
Contributor
7095 Points
1966 Posts
Mar 09, 2016 04:29 AM|anuj_koundal|LINK
Hi Amit you can view detailed discussion at: http://dba.stackexchange.com/questions/44544/stored-procedures-vs-inline-sql
Mar 09, 2016 04:55 PM|amithashenoy|LINK
THis is what i was looking for
http://forums.asp.net/t/1818517.aspx?Inline+Queries+Vs+Store+Procedure
the above thread s a discussion about stored procedure vs inline query , and Database is Sql server. But this implies same too mysql as well. hope this helps others.
Member
59 Points
197 Posts
stored procedure or select query on table Mysql
Mar 08, 2016 09:26 PM|amithashenoy|LINK
Hi,,
I want to retrieve data from table based on user input .What is the best way to do it just write Select query on table or write stored procedure.
Does it matter how much records v r retrieving in both methods ?
All the Best . Please 'Mark this Post as Answer ' if it helps you.
Contributor
7095 Points
1966 Posts
Re: stored procedure or select query on table Mysql
Mar 09, 2016 04:29 AM|anuj_koundal|LINK
Hi Amit you can view detailed discussion at: http://dba.stackexchange.com/questions/44544/stored-procedures-vs-inline-sql
Asp .Net Tutorials | www.codingfusion.com
Bank IFSC Codes
Ajax Control Toolkit
Member
59 Points
197 Posts
Re: stored procedure or select query on table Mysql
Mar 09, 2016 04:55 PM|amithashenoy|LINK
THis is what i was looking for
http://forums.asp.net/t/1818517.aspx?Inline+Queries+Vs+Store+Procedure
the above thread s a discussion about stored procedure vs inline query , and Database is Sql server. But this implies same too mysql as well. hope this helps others.
All the Best . Please 'Mark this Post as Answer ' if it helps you.