Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the openxml statement in sql server?
What do you mean by collation recursive stored procedure?
What are the steps you should follow to start sql server in single-user mode?
What are the requirements for sql server 2016?
How to create a trigger for insert only?
Explain how dts is used to extract, transform and consolidate data?
Explain why variables called the most powerful component of ssis?
Write an sql query for deleting duplicate rows?
What is subquery in sql?
What is difference between aggregate and analytic function?
What is the difference between stored procedure and functions?
How to connect to SQL Azure Database by using sqlcmd?
Explain indexed views and partitioned view with their syntax.
Explain about merge replications?
Differentiate between a primary key and a unique key.
