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 openrowset sql server?
Explain various On-Delete options in a DB table. Which is the default option?
What is the difference between resultset and resultsetmetadata?
Explain what is the purpose of sql profiler in sql server?
What is repeatable read?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is the process of normalising?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Mention the differences between sql server and mysql.
Explain what is analysis service repository?
What are the different types of triggers in SQL SERVER?
Explain linked server in sql?
How to list all schemas in a database?
