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
Explain how to maintain a fill factor in existing indexes?
What is after dml trigger?
Explain what is “asynchronous” communication in sql server service broker?
List some of the rules that apply to creating and using a ‘view’
Are connections to sql server encrypted?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
Does index speed up select statements?
How to Insert multiple rows with a single insert statement?
Explain the properties of subqueries in sql server?
What is use of except clause? How it differs from not in clause?
What are the key configuration files for sql server reporting services ?
Do you know the capabilities of cursors?
How to rebuild indexes with alter index ... Rebuild?
What triggers long term care?
How will you make an attribute not process? : sql server analysis services, ssas
