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 a deadlock and what is a live lock?
How to rename databases in ms sql server?
Explain SSRS Architecture?
Is candidate a key?
What is the use of nvl work?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is difference between drop truncate and delete?
What is exporting utility?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Is it possible in sql table to have more than one foreign key?
How to find out what is the default collation in a database?
Describe how to use linked server?
How many database files are there in sql server 2000?what are they?
What is report snapshot?
What is function of ROLLUP ?