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
Give main differences between "Truncate" and "Delete".
What is table level trigger?
What are the properties of the transaction?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
How to create a user name in a database?
How to bind a view to the schema of the underlying tables?
What are click through reports?
What is index fragmentation in ms sql server?
Is null in sql server?
What is the recommended total size of your memory optimized tables?
What is sql collation?
What is clustered index
What are the different authentication modes in sql server? How can it be changed?
what are cursors? : Sql server database administration
How many joins in sql server?
