Answer / selvaraj.v

1.A stored procedure is a precompiled collection of
Transact-SQL statements stored under a name and processed
as a unit that you can call from within another Transact-
SQL statement or from the client applications.
2.Stored procedure performs an action.
3.A collection of SQL statements often combined with
Control-of-flow statements.

1.User Defined Functions are compact pieces of Transact SQL
code, which can accept parameters, and return either a
value, or a table. They are saved as individual work units,
and are created using standard SQL commands. Data
transformation and reference value retrieval are common
uses for functions.

Answer / ashwini

1. User defined functions can be used in select statements.
Procedures can not be used.

2. Functions must return some value. Procedures do not
always return the value.

3. Functions will take only input parameters. Procedures
can take input as well as output parameters.

4. Not all types of user-defined functions use
INSERT,UPDATE,DELETE statements(Only multi-statement table
valued functions can use). All procedures can use these
statements.

Answer / manoj

1. function always run with select command while stored
procedure execute with execute command

2. function not provide output parameter facility
while stored procedure provide output facility

3. function always execute means it execute more than one
time while store procedure execute only one time

Answer / ashish

Please check out the below link. I think it may be useful:

http://newtechnobuzzz.blogspot.in/2014/07/difference-between-user-defined-funtion.html

Answer / anil sharma

Userdefined function can used in select statement.

It must return a values but in store procedure it is
optional.

Store procedure can use using sqlparameter but in
userdefined function it is not used.

Explain what is lock escalation and what is its purpose?

0 Answers  

What are views in ms sql server?

0 Answers  

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  

Explain about builtinadministrator?

0 Answers  

What is used to replicate sessions between instances in coldfusion clusters?

0 Answers   HCL,

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

How to install sql server 2005 express edition?

0 Answers  

What is difference between joins and subqueries?

0 Answers  

What is the maximum size of a row in sql server?

0 Answers  

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers