Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What's the purpose of Stored Procedure?

Answers were Sorted based on User's Feedback



What's the purpose of Stored Procedure?..

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

What's the purpose of Stored Procedure?..

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

What's the purpose of Stored Procedure?..

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

What's the purpose of Stored Procedure?..

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

What's the purpose of Stored Procedure?..

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

What's the purpose of Stored Procedure?..

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

Post New Answer

More SQL Server Interview Questions

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

1 Answers  


Can you type more than one query in the query editor screen at the same time?

0 Answers  


What is the difference between for auto and for nested?

0 Answers  


Explain indexed views and partitioned view with their syntax.

0 Answers  


How column data types are determined in a view?

0 Answers  


Explain microsoft sql server functions?

0 Answers  


How you can change the database name in SQL SERVER?

0 Answers  


How self join is different from outer join?

0 Answers   Blue Star,


What is the concept of optimization?

0 Answers  


What is difference between foreign key and unique key?

0 Answers  


What will you do If the low Performance occurs?

2 Answers  


How to locate and take substrings with charindex() and substring() functions?

0 Answers  


Categories