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
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
How to remove duplicate rows from table?
In how many ways you can invoke ssrs reports?
Name some of the open source software that you can use in alternative to SSR?
What is difference between inner join and join?
Are all views updatable ?
What happens if ntwdblib.dll is missing on your machine?
What are the steps you should follow to start sql server in single-user mode?
Is oracle faster than sql server?
Explain in brief about Microsoft SQL server?
What are the advantages of policy management?
What are .mdf files?
When columns are added to existing tables, what do they initially contain?
What is the purpose of the master database?
Why can there be only one clustered index and not more than one?