Difference between writing SQL query and stored procedure ?
Answers were Sorted based on User's Feedback
Answer / ramneet
SP is good for security purpose, as it grant privileges to
the use.........
Is This Answer Correct ? | 23 Yes | 20 No |
Answer / shivangi rastogi
in sql query,there is not security features since when we
write a query in our programe,through ildasm command it
will show thw query to the public.
in stored procedure,we named a set of query & it works as a
file name whenever anyone checks the query it ll find the
procedure name not that query onwhich our programe is
running.
in sql query,if any error in query it ll compiled & show
error at runtime,which is not in stored procedure.
Is This Answer Correct ? | 8 Yes | 5 No |
Answer / anbu arunmozhi
Query execute every time when ever u call that statement
but stored procedure execute only one time v can used every time it should be very efficient compare query
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / tmp
the main advantages is Execution Plan Retention and Reuse (SP are compiled and their execution plan is cached and used again to when the same SP is executed again)
http://blog.sqlauthority.com/2007/04/13/sql-server-stored-procedures-advantages-and-best-advantage/
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / komal sankhe
compared with sql query, stored procedure is efficient and
timesaving execution.Because stored procedure is program
once it formed then execute as a program at the same
time.coz queries are taking the time
Is This Answer Correct ? | 19 Yes | 22 No |
What are some examples of schemas?
What do you understand by recursive stored procedures?
How to create dbo table in sql server?
Can a unique index be created on a column, which contains null?
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?
What are the different types of locks in the database?
What is Query Execution Plan? How does it help optimize or tune a database driven application?
what is the main difference between constraints(like primary key etc..)& joins?
Differentiate between a local and a global temporary table?
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?
What are commonly used odbc functions in php?
What are the types of sql server?