Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 22190 Views
- C1 India, NA, I also Faced
- E-Mail Answers
Answer Posted / arvind kumar
1-Function can not return the value but store procedure
return value
2-Store procedure is pree-compile statement but function is
not pree-compile satement.
3 function fallowed by select statement but store procedure
fallowed select, insert,update statement.
| Is This Answer Correct ? | 2 Yes | 40 No |
Post New Answer View All Answers
Describe triggers features and limitations?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
Explain the ways to controlling cursor behavior?
What are character string data types in ms sql server?
What is a transaction and why is it important?
How you can minimize the deadlock situation?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How to list all user names in a database?
Explain the cursor lock types?
What is the rdl file?
Which trace flags are enabled in sql server?
How to disable a login name in ms sql server?
What is unique key constraint?
What will be the maximum number of indexes per table?
What is clr ddl trigger?
