Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 22187 Views
- C1 India, NA, I also Faced
- E-Mail Answers
Answer Posted / madhu
stored procedure when executed generates execution plan
once and next time when it is executed again it will use
the generated execution plan,it does not generate it again.
Function compiles from the beginning and prepares the trace
or execution each time it is called.
| Is This Answer Correct ? | 20 Yes | 5 No |
Post New Answer View All Answers
What is a fan-out query in SQL Azure?
What is sql injection? How to protect against sql injection attack?
Why the trigger fires multiple times in single login?
How do I find sql server instance name?
What are the basic functions for master, msdb, model, tempdb databases?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What is user-defined function?
Can we insert data into a view?
How to generate create view script on an existing view?
How to rebuild indexes with alter index ... Rebuild?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
How to create a login account in ms sql server to access the database engine using "create login" statements?
List out some of the requirements to set up a sql server failover cluster?
Indexes are updated automatically is the full-text index also updated automatically?
