Answer Posted / shekharjchandra

Hope u mean the below question

can we write stored function in out parameters? how to call
through select statement? how to written more than one
value plz give the exmple?

As

can we write stored function in out parameters? how to call
through select statement? how to RETURN more than one
value plz give the exmple?

------
We can write stored function with both IN and OUT parameters.

We can call from select statement only if there is no OUT parameter in it, and that too the called function should not modify the table data what is referred in Select statement.
And other condition it should not return multiple values when it is referred in Select statement

In order to return more then one value you have to use OT parameters or return the value as record and loop through the returned values.

Regards
J

Explain table and field in sql?

1055

---

What is normalization? How many normalization forms are there?

1078

---

Which table is left in join?

964

---

What version is sql?

1017

---

What are literals in sql server?

1152

---

How many types of primary keys are there?

1026

---

How to fetch alternate records from a table?

1221

---

what is a trigger in mysql? : Sql dba

1136

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

960

---

What does over partition by mean in sql?

965

---

What is cursor status?

1180

---

What are tables and fields?

1025

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3996

---

How do I make my sql query run faster?

932

---

what is the functionality of the function htmlentities? : Sql dba

941

---