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
Explain collation?
What is 2nf example?
Can we use max in where clause?
What happens if the update subquery returns no rows in ms sql server?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What is a derived table?
What are Spatial data types in SQL Server 2008
Explain identity in sql server?
What's the information that can be stored inside a bit column?
How do you handle datasets larger than 50 gb?
What are a database and a data warehouse?
Name 3 ways to get an accurate count of the number of records in a table?
What are the three different part of rdl file explain them?
What is the difference between Clustered and Non-Clustered Index?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
