Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Userdefined function and
stored procedure? Explain and give the example also
- 5 Answers
- 10606 Views
- I also Faced
- E-Mail Answers
Answer Posted / manoj
1. function always run with select command while stored
procedure execute with execute command
2. function not provide output parameter facility
while stored procedure provide output facility
3. function always execute means it execute more than one
time while store procedure execute only one time
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is sqlservr.exe - process - sql server (sqlex?press)?
What is hot add cpu in sql server 2008?
What are the properties of the transactions?
Explain powershell included in sql server 2008?
What is 2nf normalization form?
Explain syntax for viewing, dropping and disabling triggers?
Explain the various types of concurrency problem?
what do you understand by change data capture?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What is ms sql server service broker?
What is the difference between implicit and explicit transaction?
Explain transaction isolation levels in sql server?
Explain what are the different index configurations a table can have?
