What are the differences between stored procedure and
functions in SQL Server 2000?
Answers were Sorted based on User's Feedback
Answer / shrngika
function contains the no. of line which gives a result
according to your input.
while in procedure you can call function.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / chauhan rakesh botad
1>Procedure can return zero or n values whereas function can
return one value which is mandatory.
2>Procedures can have input,output parameters for it whereas
functions can have only input parameters.
3>Procedure allow select as well as DML statement in it
whereas function allow only select statement in it.
4>Functions can be called from procedure whereas procedures
cannot be called from function.
5>Exception can be handled by try-catch block in a procedure
whereas try-catch block cannot be used in a function.
6>We can go for transaction management in procedure whereas
we can't go in function.
7>Procedures can not be utilized in a select statement
whereas function can be embedded in a select statement.
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / tarun waia
function cant return Result set where
procedure can
Is This Answer Correct ? | 17 Yes | 45 No |
Answer / lrk
The Text property exposes the Transact-SQL or other script
that defines the referenced Microsoft? SQL Server? 2000
database object.
The FunctionName property specifies the function name to
call in the Microsoft? ActiveX? script associated with a
script task or step.
Is This Answer Correct ? | 38 Yes | 73 No |
What is normalization process?
What is a deadlock and what is a live lock?
What is the difference between the application object and session object?
What do you mean by collation recursive stored procedure?
How do database indexes work?
what are cursors? : Sql server database administration
Who is the owner of a schema in ms sql server?
if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..
17 Answers 3i Infotech, Rolta, TCS,
What are the disadvantages of using the stored procedures?
what is normalization? Explain different levels of normalization? : Sql server database administration
How to defragment table indexes?
can we call stored Procedure in Function in Sql Server 2000 and vice versa.
3 Answers C3I, eSoft, iPRO Solutions, Wipro,