Answer / shrngika

function contains the no. of line which gives a result
according to your input.
while in procedure you can call function.

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.

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.

Answer / tarun waia

function cant return Result set where
procedure can

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.

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

How do I setup a local sql server database?

0 Answers  

How many triggers are possible per table?

0 Answers  

Can you force a query to use a specific index?

0 Answers  

How to check if stored procedure is running in sql server?

0 Answers  

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  

What is the full meaning of dml?

0 Answers  

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

Does a sql server 2005 select statement require a from?

0 Answers  

What is model database in sql server?

0 Answers  

How can we delete a table in sql server?

0 Answers  

what is the maximum size of a row? : Sql server database administration

0 Answers