Answer Posted / pradeep aryan
1. Function can returtn single value but proc san return
multiple values
2. Proc can call a function but function not.
3. function can call in select statement also and acn perform
action also but proc not.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do I start sql server 2017?
What is sql or structured query language?
When should you use an instead of trigger?
What is an indexed view?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
List the ways in which dynamic sql can be executed?
What is clustered index
How efficient you are in oracle and SQL server?
What is standby servers? Explain types of standby servers.
What is the difference between for xml raw and for xml auto?
How can we solve concurrency problems?
Disadvantages of the indexes?
Explain system functions or built-in functions? What are different types of system functions?
Can you index views?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
