when we use function instead of procedure? plz tell me the
situation with ex?
Answer Posted / adil khan
procedure can only use in plsql not in sql. in other words
you can not use procedure in your select satatement. only
funtion can be used for example max(),min(),Avg() these all
are funtion not procedure.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is 'write-ahead log' in sql server 2000 ?
What is relationship? What number of sorts of relationship are there?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is the difference between count and distinct count?
What is a document index?
Please differentiate between a local and a global temporary table?
List the different types of collation sensitivities in sql server?
How do you make a trace?
How to view the error log for any specific instance? : sql server database administration
When do you think a developer should use sql server-based cursors?
How to change parameter value inside the report?
Which sql server table is used to hold the stored procedure scripts?
What are the different kinds of ssrs reports?
What are magic tables in sql server?