Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76790 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 meant by indexing?
Do you know the different ddl commands in sql?
How to create an multi-statement table-valued function?
where the connection string store in the database
How can sql injection be stopped? : sql server security
How to handle error or exception in sql?
Is mysql better than sql server?
Is the primary key column of a table an index in ms sql server?
What is db stored procedure?
What is an index in sql?
Is sql server is free?
What is fill factor and pad index?
What is the difference between a function and a trigger?
How to perform backup for certificates in sql server? : sql server security
What is sql server replication? : sql server replication
