Answer / 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

What are the different types of dbmss?

0 Answers  

---

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

---

Explain how to use transactions efficiently : transact sql

0 Answers  

---

What is pl sql package?

0 Answers  

---

What is normalisation in sql?

0 Answers  

---

What is triggering circuit?

0 Answers  

---

What is the max nvarchar size?

0 Answers  

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  

---

How would you hide a table in sql. ie the table can be only visible to its maker?

3 Answers  

---

What is sqlca in powerbuilder?

0 Answers  

---

What are the different types of sql commands?

0 Answers  

---

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

---