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
Explain the concepts and capabilities of sql server?
What is the difference between having clause and where clause in sql server?
What are the events recorded in a transaction log?
How do you create a clustered index?
What is deploy, process and build? : sql server analysis services, ssas
How display code or Text of Stored Procedure using Sql query in Sql Server ?
what happens on checkpoint? : Sql server database administration
What is collation?
What is self join in sql server joins?
How to generate create view script on an existing view?
How to write a query with a full outer join in ms sql server?
How many levels of sp nesting is possible?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What do you mean by an execution plan? Why is it used? How would you view it?
How column data types are determined in a view?