when we use function instead of procedure? plz tell me the situation with ex?

when we use function instead of procedure? plz tell me the
situation with ex?

Question Posted / senthilsjc

3 Answers
11073 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

when we use function instead of procedure? plz tell me the situation with ex?..

Usually procedures are used when some action is to be
performed without retrun value.
Functions are used when some value is to be returned to the
calling enviornment.
You can not use procedure in the select statement however
functions can be used.

Is This Answer Correct ?

30 Yes

0 No

when we use function instead of procedure? plz tell me the situation with ex?..

Answer / priya

can we use default value in unique key?

Is This Answer Correct ?

4 Yes

2 No

when we use function instead of procedure? plz tell me the situation with ex?..

Answer / adil khan

procedure can only use in plsql not in sql. in other words
you can not use procedure in your select satatement. only
funtion can be used for example max(),min(),Avg() these all
are funtion not procedure.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More SQL Server Interview Questions

how to delete duplicate rows in sql server2005

7 Answers Cisco, CTS, HCL, IBM,

How to connect sql server management studio express to sql server 2005 express?

0 Answers

Define clusters?

0 Answers

What is the difference between a local and a global temporary table?

0 Answers

What is page-level compression?

0 Answers

What is blocking and how would you troubleshoot it? : sql server database administration

0 Answers

What are the rules to use the rowguidcol property to define a globally unique identifier column?

0 Answers

Can I work with several databases simultaneously? : sql server management studio

0 Answers

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers Perot Systems,

What is clustered index

0 Answers

What are constraints? Explain different types of constraints?

26 Answers Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

What is xdr?

0 Answers

For more SQL Server Interview Questions Click Here