Answer Posted / hardik
stored procedures are bunch of SQL queries. main advantage
of stored procedure is that it is a self compiled and
execution speed is faster than normal query.
for e.g.
if we write select * from tablename and if we make stored
proc for that statement it will execute faster than normal
query.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What do you understand by integration services in sql server?
In which files does sql server actually store data?
Explain can SSRS reports Cache results?
What are the types of normalization?
What is sql injection? How to protect against sql injection attack?
What are the default system databases in sql server 2000?
What xml support does the sql server extend?
What is field in algebra?
What is a functions and types in sql server?
What are the dmvs?
What is replace and stuff function in sql server?
What is normalization? Explain its different types?
What are the different types of collation sensitivity in sql server?
What is multilevel indexing?
What is onf in normalization form?
