Difference between writing SQL query and stored procedure ?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / shaheen

15 Answers
71813 Views
Cognizant, Infosys, TCS, Veritas, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Difference between writing SQL query and stored procedure ?..

Answer / ramneet

SP is good for security purpose, as it grant privileges to
the use.........

Is This Answer Correct ?

23 Yes

20 No

Difference between writing SQL query and stored procedure ?..

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

Difference between writing SQL query and stored procedure ?..

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

Difference between writing SQL query and stored procedure ?..

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

Difference between writing SQL query and stored procedure ?..

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

Post New Answer