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 is the cpu pressure?
What is difference between Triggers and store procedure?
How many database files are there in sql server 2000?what are they?
What do you understand by a view?
What is transaction server isolation?
What is the difference between SQL notification and SQL invalidation?
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?
How do I create a stored procedure in sql server?
What does the update command do?
What is transcation?Plz give One example?
How to get a list of columns using the "sys.columns" view in ms sql server?
Find columns used in stored procedure?