Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / manisha
Stored procedured are precompiled and preoptimized sql stmts
so it takes less processing time,means executes much faster.
Can be shared between multiple user,so more reusable.
Much easier to manage it,since it resides in DB
more secure,flexible
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
What are the steps you should follow to start sql server in single-user mode?
What are the restraints imposed on the table design by a merge replication?
Who is the owner of a schema in ms sql server?
Does table partitioning improve performance?
What is the native system stored procedure to execute a command against all databases?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
Are null values the same as that of zero or a blank space?
What is 2nf normalization form?
What is the Disadvantage of indexed sequential file.
Explain identity in sql server?
What is cross join in sql server joins?
What is temporary stored procedure?
In what three ways is the return statement used in a stored procedure?
can any body tell me how to know the password of current user in sql server
What are number line correlation administrators will use while working with a subquery?
