Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function.
- 4 Answers
- 8955 Views
- Thomson, I also Faced
- E-Mail Answers
Answer Posted / saurav kumar
1) Inside Stored procedure we can write functions but
inside function we can't write Stored procedures.
2) Stored proedure may or may not return a value but
function must return a value.
3) Stored Procedures can be called independently using exec
keyword ,Function are called using select statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When would you use a before or after trigger?
Explain what are partitioned views and distributed partitioned views?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
Explain active/passive and active/active cluster configurations?
Explain security with sql azure?
When multiple after triggers are attached to sql table, how to control the order of execution?
How to call a function from a stored procedure in SQL Server ?
What is the name of reporting services config file and what’s it’s used for?
Do you know the policy based administration feature of sql server 2008?
What is the significance of master, tempdb and model databases?
What is tabulation?
Explain the difference between primary keys and foreign keys?
How data can be copied from one table to another table?
Why use sub query in sql server and list out types of sub queries?
Do you know how to store and query spatial data?
