What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / chandu
17) Difference between stored procedure and functions?
Stored Procedures
I) Stored procedure takes input and output parameters.
II) Stored procedure contain all DML operations with
permanent table
III) Return statement can return single numeric value.
Functions:
I) functions takes only input parameters
II) function contains only select statement to perform
operation with permanent table
III) It returns single value or set of rows.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Explain the collation?
Explain table valued parameters in sql server? Why tvp used?
What is a trigger and types of a trigger?
between cast and convert which function would you prefer and why?
What are the recovery models in sql server 2000?
How can you hide the sql server instances?
What are the key configuration files for sql server reporting services ?
Explain the etl (extraction, transformation, and loading)?
What is msdb database? : SQL Server Architecture
How can you set the threshold at which sql server will generate keysets asynchronously?
What is the difference between seek predicate and predicate?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Is ssrs support other database except ms sql server?
Define Wed Edition in SQL Azure?
Why can there be only one clustered index and not more than one?