Difference between Function and Stored Procedure?
Answer Posted / raj..
The difference mejor between procedure and function is that
function must return value. that should be only single and
function can pass any no. parameter but come out only one
value only using return statement.
procedure can pass any parameter and came out any no. of
values there no any RETURN word.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
where can you add custom error messages to sql server? : Sql server administration
Explain the different index configurations a table can have?
What is a database table?
What are the purposes and advantages stored procedure?
Explain stored procedure?
Why union all is faster than union?
Describe the functionalities that views support.
what are the reporting service components in SSRS?
How to define output parameters in stored procedures?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
what's the difference between delete table and truncate table commands? : Sql server database administration
How can we use ConnectorJ JDBC Driver with MS SQL?
How can I create a report based on a query? : sql server management studio
What is an index in sql?
What is normalization? Explain different forms of normalization?