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 importance of concurrency control?
Is truncate a dml command?
How to name query output columns in ms sql server?
What is forward - only cursors / read only cursor?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is named calculation? : sql server analysis services, ssas
what are different types of raid configurations? : Sql server database administration
can SSRS reports Cache results?
Do you know how to store and query spatial data?
What is resource governor in sql server?
Can you tell me some of the common replication dmv's and their use? : sql server replication
How do you troubleshoot errors in a SQL Server Agent Job?
What do you mean by collation recursive stored procedure?
what exactly sql injuction.how to overcome.....
What is TDS(Tabular Data Stream) Gateway?
