Interested to Buy Any Domain ? << Click Here >> for more details...
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
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Do you know what are various aggregate functions that are available?
What is log ldf?
What is sql server 2000 work load governor?
What are the drawbacks of reporting in ssrs?
explain extended properties
What is the difference between value type and reference type?
What are the different types of replication are there in sql server 2000?
What is a not null constraint?
What is the xml datatype?
What is an indice?
Tell me what is normalization? Explain different forms of normalization?
what are acid properties? : Sql server database administration
Describe how to use the linked server?
What is the difference between migration and upgradation in sql server?
