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
- 111991 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
What is explicit cursors?
How important do you consider cursors or while loops for a transactional database?
What is the difference between varchar and varchar types?
What are the advantages of using stored procedures?
What is difference between cte and view?
difference between Clustered index and non clustered index ?
Why use update_statistics command in sql server?
How do I debug a stored procedure in sql server?
What is the use of set nocount on/off statement?
Why use stored procedures in sql server?
How to create dbo table in sql server?
what is the difference between count(*) and count(1) ?
What are the export options of ssrs?
What does it mean to manipulate data?
What are the advantages of sql azure?
