What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / nazeema
Stored procedures can change server environment and our
operating system environment.
Function can not change server environment and our
operating system environment.
Stored procedures are stored in parsed and compiled format
in the database.
Functions are compiled and executed at run time.
Stored procedure return more than one value or Dataset.
Fuction can return a single value only.
error handling can be done in Stored procedure.
it not possible in function.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to create “dependant” parameter “make, model, year”
Define left outer join?
How to restore performance issues and how to check?
How to rebuild all indexes on a single table?
What is SQL Server?
What are four major operators that can be used to combine conditions on a where clause?
Does group by or order by come first?
Can select statements be used on views in ms sql server?
What are wait types?
Explain the difference between HTTP and HTTPS in database?
What is the report builder?
What is the beast way to write CTE in SQL Server ?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
Tell me what do we need queues in sql service broker?