Interested to Buy Any Domain ? << Click Here >> for more details...
difference between function and procedure
- 3 Answers
- 5385 Views
- Cognizant, HCL, TCS, Theorem, I also Faced
- E-Mail Answers
Answer Posted / ramya
1.a function must returns a value where as procedure may not return value
2.a procedure can have parameters of both i/p and o/p but
fun has only i/p parameters
3.in procedure we can perform all the dml operations but in function only select operation should be performed
4.we call a procedure by using 'exec' or 'execute' command where as function is called by using 'select' command
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is standby servers? Explain types of standby servers.
explain extended properties
What are binary string data types in ms sql server?
Explain a join?
List the different normalization forms?
Explain what role entity and relationship play in an ER diagram.
Why are sql functions used?
What methods do you follow to protect from sql injection attack?
What is an sql server agent?
What are the export options of ssrs?
Explain the truncate command?
Can a table be created inside a trigger?
What is the difference RDBMS and Graph Database?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How you can get a list of all the table constraints in a database? : Sql server administration
