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
What is 3nf normalization?
What is the correct order of the logical query processing phases?
What is local temp table?
How to find out what is the default collation in a database?
Explain for xml explicit mode?
What do you mean by sql server agent?
What are ddl (data definition language) statements for tables in ms sql server?
What is t-sql script to take database offline – take database online.
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
What is transaction server distributed transaction?
How to optimize stored procedure optimization?
What is index in an assignment?
What are different types of views?
What is the data tier application?
Explain about system stored procedure?