when we use function instead of procedure? plz tell me the
situation with ex?
Answer Posted / manoj
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 |
Post New Answer View All Answers
Please differentiate between a local and a global temporary table?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Why we use trigger in sql server with example?
Benefits of Stored Procedures?
What is inline variable assignment?
What is use of except clause?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Can a table have 2 foreign keys?
How to grant a permission in ms sql server using "grant execute" statements?
What's the information that can be stored inside a bit column?
What is difference between rollback immediate and with no_wait during alter database?
What is database mirroring?
What is table constraint?
How can you start sql server in different modes?
How do clustered indexes store data?