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.

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.

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

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

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.

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

How can I check if a view exists in a sql server database?

0 Answers  

‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  

Explain about the command-line tool SQLCMD?

0 Answers  

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

What are the advantages of log shipping?

0 Answers  

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

Why Do you want to work in this company?

4 Answers   HCL,

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

How do I start sql server 2016?

0 Answers  

How can you append an identity column to a temporary table?

0 Answers  

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers