Jump to content

Stored Procedure


vijay
 Share

Recommended Posts

HiPlease tell me the difference of following 2 things-->(1) to pass all possible parameter that generate query at SQL Server side and execute it--->(2) OR to build query at web server (in php/cfml file in one string variable) and passed it in to stored procedureRegards,Vijay

Link to comment
Share on other sites

I think you are confusing the terminology.A Stored Procedure is a query or group of queries that are 'saved' and run at the database server level.Creating the query at the code level (php,etc) is not a stored procedure.You can execute a stored procedure from your code but a Stored Procedure is on the database.Which is better???? It has been argued both ways for a long time. I do not really have an answer for you. I like to create Stored Procedures for large groups of queries and smaller stuff I build at the code level.

Link to comment
Share on other sites

Like I said before this is a big arguement in the database world.Some say Stored Procedures are better and faster and Others say building your queries at the code level is faster.I personally think that running a large number of queries as a stored procedure would be faster and when running small queries the code level would be faster.I do not have any proof to back this up but that is what I think.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...