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 do you understand by triggers?
How to generate create procedure script on an existing stored procedure?
List out different types of normalizations in sql server and explain each of them?
How to download and install microsoft .net framework version 2.0?
What are the source of constraints?
How to connect a database with sql express.?
Define cursor locking
What is sql or structured query language?
How do you debug a procedure in sql server?
What will be query used to get the list of triggers in a database?
What is temporary stored procedure?
Can we add our custom code in ssis?
what are the three command line utilities and what are their primary functions?
What is the main difference between ‘between’ and ‘in’ condition operators?
What is 4nf in normalization form?
