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
How to create a simple table to test triggers in ms sql server?
Differentiate between mongodb vs. Sql server?
Can you pass expressions to stored procedure parameters?
What is a non equi join?
What is the report builder?
How to create a local temporary stored procedure?
What is update_statistics command?
Explain differentiate between a having clause and a where clause?
What are user-defined functions (udfs) in sql server?
What it means to be triggered?
What is self contained sub query?
how to invoke a trigger on demand? : Sql server database administration
What is 1nf normalization form?
Is it safe to delete log files?
How to disable triggers using "disable trigger"?
