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 deploy, process and build? : sql server analysis services, ssas
What is the data type of time?
You want to implement the one-to-many relationship while designing tables. How would you do it?
Which Model uses the SET concept
What are the dmvs? : sql server database administration
Where is localdb stored?
What is cdc in sql server?
What is an sql server agent?
Explain cross join or cartesian product in sql?
Do you know what are acid properties of transaction?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What are the difference between “where” and “having” clause in sql server?
What do you mean by SQL injection attack?
What is an inner join?
What is the syntax to execute the sys.dm_db_missing_index_details?