Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76206 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
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 |
which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help
How can we remove orphan records from a table?
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h
Which one is faster delete/truncate? Why?
What is difference statement and preparedstatement?
What is user defined stored procedures?
How do I trace a query in sql server?
I have student marks in a student table. I need second highest mark .Then what will the query for this?
37 Answers NetCore, Patni, SAP Labs, Temenos, Wipro,
Do you know what is a linked server in sql server?
What is the purpose of grouping data in a report?
how can u select the Distinct values in the table, table having 20 columns , i want all columns
How connect excel to sql server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
