Interested to Buy Any Domain ? << Click Here >> for more details...
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 is the difference between index seek vs. Index scan?
What do you understand by sql server agent?
Where are sql server user names and passwords stored in sql server?
Can you index views?
Explain cursor as data base object?
What are the various editions of sql server 2017 that are available in the market?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
what is the system function to get current user's user id? : Sql server database administration
List the different normalization forms?
role of sql sever 2005 in database rather than any other database
What is multilevel indexing?
Define normalisation?
Explain query editor regions
What is model database in sql server?
what are the three command line utilities and what are their primary functions?
