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
How many ways to create table-valued functions?
What happens if strings are casted into wrong code pages in ms sql server?
Difference between aggregate functions of sql?
Can we insert data into view sql server?
What is transaction server distributed transaction?
What is the syntax for encrypting a column in SQL Server?
What does asynchronous call backs means?
How do you open a cluster administrator?
What are user defined functions in ms sql server?
Does transparent data encryption provide encryption when transmitting data across the network?
Explain what is public role in sql server?
Find columns used in stored procedure?
Can we insert data if clustered index is disabled?
Explain how many types of relationship?
What is database replication?