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 are the restraints imposed on the table design by a merge replication?
How many columns can we include on clustered index ?
What is candidate key with example?
What is an expression in ms sql server?
How to set database to be single_user in ms sql server?
Can you import Microsoft Excel data to SSRS?
How do I start sql server 2016?
Explain what is cte (common table expression)?
what are the three command line utilities and what are their primary functions?
What is mean by candidate key?
What are “lock” hints?
how to take backup bcp out for a column in table in sql server?
What are dml triggers and types of dml triggers?
What is self contained scalar sub query?
What are cursors in ms sql server?
