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.

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

How to write a query with an inner join in ms sql server?

0 Answers  

When we should use @@error?

0 Answers  

Can we update data in a view?

0 Answers  

What is the difference between cartesian product and cross join?

0 Answers  

Describe and explain about SQL native client?

0 Answers  

What are 3 ways to get a count of the number of records in a table?

0 Answers  

How to execute a sql statement using mssql_query()?

0 Answers  

What are the advantages of using cte?

0 Answers  

What is outer join in sql server joins?

0 Answers  

How do you create type- insensitive operator?

0 Answers   EXL,

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers