Interested to Buy Any Domain ? << Click Here >> for more details...
What's the purpose of Stored Procedure?
- 6 Answers
- 18529 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / koti khammam
It will reduce the network traffic between client and
server so that the number of calls between client and
server are reduced.
It's an performance issue.
| Is This Answer Correct ? | 23 Yes | 5 No |
Answer / dharmendra k. dixit
Stored Procedures has some advantages thats y we are using
SP..
some advantages are..
(1)Stored Proc is a Pre Compiled statement..so its reduces
Network Traffic.
(2). We can execute SP inside SP.
(3). Through it we can protect from SQL Injection.
| Is This Answer Correct ? | 17 Yes | 3 No |
Answer / manisha
Stored procedured are precompiled and preoptimized sql stmts
so it takes less processing time,means executes much faster.
Can be shared between multiple user,so more reusable.
Much easier to manage it,since it resides in DB
more secure,flexible
| Is This Answer Correct ? | 16 Yes | 3 No |
Answer / suresh
Stored Procedure Accept input Parameter,So a single stored
procedure can use Over the Network by several Clients by
Passing several Input values
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / m.k.manikandan
There are several purposes of using stored procedures
instead of standard SQL. First, stored procedures allow a
lot more flexibility offering capabilities such as
conditional logic. Second, because stored procedures are
stored within the DBMS, bandwidth and execution time are
reduced. This is because a single stored procedure can
execute a complex set of SQL statements. Third, SQL Server
pre-compiles stored procedures such that they execute
optimally. Fourth, client developers are abstracted from
complex designs. They would simply need to know the stored
procedure's name and the type of data it returns.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / ashish
Sp is secure if we input data through query that time Haker
will hack this database easily
But in SP haker can not hack easily means DATA Manipulation
through SP is Secure the QUERY statement in any Language Coding
| Is This Answer Correct ? | 3 Yes | 3 No |
How to find tables without indexes?
What is the difference between HAVING clause and the WHERE clause?
What is read uncmmited?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.
How to transfer an existing table from one schema to another schema in ms sql server?
How will you add a dimension to cube? : sql server analysis services, ssas
What is @@error in sql?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What are the dis_advantages of stored procedures, triggers, indexes?
What is the difference between Normalization and De-normalization?
What do we have to check in database testing?
-
Oracle (3253) - 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)
