Difference between inline query and stored procedure?
Answer Posted / sharad prakash singhania
Procedure resides in the database in the executable format
whereas in case of inline query, SQL always take a step to
compile the query and then execute it. So In this respect
Procedure takes less time to execute whereas query take more
time to execute.
Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
What is cost in sql execution plan?
What is view explain with example?
How can get second highest salary in sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Where do we use pl sql?
How do I audit the sql sent to the server?
Can you inner join the same table?
explain advantages of myisam over innodb? : Sql dba
What is parallel hint?
What is a database trigger?
What is the difference between alter trigger and drop trigger statements?
What is the difference between microsoft access and sql server?
Define select, insert, create, delete, update, drop keywords
What is audit logout in sql profiler?
What is column?