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
- 112812 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 normalization? What number of normalization shapes are there?
How can i Relate Tables in SSIS
Why do we need different type of parameter?
How to compare the top two records using sql?
What is public role in sql server?
What is ssl in sql server?
Which are ddl commands?
How to create a new table in a given schema?
What are the basic functions for master, msdb, model, tempdb databases?
How to see existing views in ms sql server?
What stored procedure can you use to display the current processes?
on line cluster can we make if yes tell me the procedure
in the physical file layout, where should the transaction log be stored in relation to the data file?
What is check constraint in sql server?
What are indexers?
