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
- 113708 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
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
Explain trigger and trigger types?
What is outer join in sql server joins?
Can you insert NULL in unique column?
write an SQL query to list the employees who joined in the month of January?
What is the significance of null value and why should we avoid permitting null values?
your distribution database is full what will u do
What is the difference between online clustering and Offline clustering?
What is the difference RDBMS and Graph Database?
What is the web service used for reporting services?
How to fetch the next row from a cursor with a "fetch" statement?
Explain how you can deploy an SSRS report?
What is dbcc? Give few examples.
How do I find information about the install locations for the various instances running on a computer?
How to enable tcp/ip protocol on a sql server?
When would you use it?
