What is a Stored Procedure?
Answers were Sorted based on User's Feedback
Answer / guest
Its nothing but a set of T-SQL statements combined to
perform a single task of several tasks. Its basically like a
Macro so when you invoke the Stored procedure, you actually
run a set of statements.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / dharmendra k. dixit
An Stored Procedure is basically a set of T-SQL Statement,
it hv lot of benifits thats y we are using SPs.
Some are the advantages of Stored Procedures.
1. it reduses the Network Traffic.
2. we can execute SP inside SP.
3. it takes slower time in execution bcz its a
preCompiled statement.
4. create once and can use multiple times.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / hardik
stored procedures are bunch of SQL queries. main advantage
of stored procedure is that it is a self compiled and
execution speed is faster than normal query.
for e.g.
if we write select * from tablename and if we make stored
proc for that statement it will execute faster than normal
query.
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / santhanakumari
SP r nothing but collection of SQL stments and control flow
of language.it execute very fastly than a stand alone sql
statment because its a precompiled statement.SPs r reduce
the network traffic
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / peter nguyen
Stored procedures are a set of control flow SQL queries.
Main advantage of stored procedure: it is a precompiled
statement, hence:
Some advantages of Stored Procedures are:
1. It reduces the Network Traffic.
2. We can execute standard procedure inside standard
procedure
3. Execution faster because it’s a precompiled statement.
4. Create once and may re-use multiple times.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / raghuram
Stored procedure is a set of T-Sql statements combined to
perform a single task of multiple tasks. It do not run
values, It performs only tasks. It reduces network traffic
and improve the performance. It accepts the input
parameters. It helps to ensure the integrity of the
database.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nivedita
Stored procedures are "defined once, used many times."A
stored procedure is written using Transact-SQL (T-SQL). T-
SQL is a subset of ANSI SQL-92 that has extensions to the
Standard. T-SQL includes variables, conditional logic,
loops and flow control.A stored procedure allows you to put
code or business logic on the database server.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / babu
stored procedure is PL SQL statement that is called by a name
procedure perform a task, they does not return value.
1.reduce network traffic
2.reduce server overhead
3. Excution plan may be reused
4.provide good security for our data
Is This Answer Correct ? | 0 Yes | 0 No |
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.
What is a sql join?
What is difference between index seek vs. Index scan?
What is create command?
What are the advantages of having an index on the sql server?
what is Data Transformation Services (DTS) ?can u explain me in detail?
What is a Join and explain its types?
what is create database syntax? : Sql server database administration
What is store procedure? When do you use?
How to test a dml trigger in ms sql server?
Can a table have 2 foreign keys?