Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 112975 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / jitendra
>Procedure may return none or more values.
->Function must always return one value either a scalar value or a table.
>Procedure allow modular programming.
>Function can be used in a select statement where as procedure can't.
>procedure can input and output parameter but Function takes only input parameter.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between createstatement and preparedstatement?
What is difference between joins and subqueries?
What is query optimization process?
How many clustered indexes there can be on table ?
Do you know what are the properties of the relational tables?
Explain what is row_number function?
How can delete duplicate records in cte in sql server?
When to use null data driven subscription?
List out the different types of locks available in sql server?
Explain the difference between delete,drop and truncate in SQL Server?
Can you please explain the difference between function and stored procedure?
How to create a view on an existing table in ms sql server?
What is co-related sub query?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is a trigger and types of a trigger?
