What are the differences between stored procedure and
functions in SQL Server 2000?
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
between cast and convert which function would you prefer and why?
Explain the steps to create and execute a user-defined function in the sql server?
How to use column default values in insert statements in ms sql server?
How to assign new column names in a view?
What is page-level compression?
How can you find out how many rows returned in a cursor?
Explain trigger and its types?
Define candidate key, alternate key, and composite key.
What is collation?
Explain why variables called the most powerful component of ssis?
What are the characteristics of modern DBMS?
What do I need to start working with sql studio? : sql server management studio
Does transparent data encryption provide encryption when transmitting data across the network?
In which files does sql server actually store data?
how you can configure a running aggregate in SSRS?