Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76940 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / robinson
The execution plan will be created when compiling the stored
procedure and permanently stored in the database and so it
is much efficient, But in the case of query the execution
plan will be created at runtime.
| Is This Answer Correct ? | 30 Yes | 9 No |
Post New Answer View All Answers
What is function of CUBE ?
What extended events?
What are wait types?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Can we check locks in database? If so, how can we do this lock check?
How to call a function from a stored procedure in SQL Server ?
What is the difference between getdate and sysdatetime?
Is mysql better than sql server?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
How to delete a login name in ms sql server?
Difference between primary key and clustered index?
What is sql azure database?
What is an execution plan?
what is hash nonclustered index
