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 difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
what is an index? : Sql server database administration
What is ssl in sql server?
Tell me what are cursors and when they are useful?
What is sql injection and why is it a problem? : sql server security
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
How do I find the sql server instance name?
what is a check constraint?
Explain transaction server distributed transaction?
How can sql server instances be hidden? : sql server security
Explain different types of collation sensitivity?
How many types of triggers are there?
What are the advantages of using cte?
What is difference between commit and rollback when used in transactions?
What is data compression? : sql server database administration
