How to return more than one value from a function?
Answers were Sorted based on User's Feedback
Answer / highness
you can pass the value back to the user
by using the OUT parameter;
but mostly function is used to return only one value..
its like to compute the task and to return a value;
?? but in this case why dont u opt for a procedure, since its
designed to handle this type of situations...
| Is This Answer Correct ? | 2 Yes | 10 No |
What is the most restrictive isolation level? : Transact sql
What are the advantages of stored procedure?
What is the difference between drop and truncate commands?
What is schema in sql?
What is trigger in sql?
How to run sql statements through the web interface?
How does index help in query performance?
What are triggers, and when would you use them?
How to get help at the sql prompt?
how to delete an existing column in a table? : Sql dba
How can you load multi line records? : aql loader
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)