Answer / sachin

We can't call sp inside query insted we can call Function
inside query,infact that is the major difference between
the SP and Function

Answer / rajasekaran

no we can't call SP inside a query

Answer / aagstya

No We can not call SP inside any query! We can call only
function in query.
This is the major difference in between SQL Function and
SQL Stored Procedure

Answer / radhakrishnan

No, we can't call sp in query.

Eg:this query not working properly

select empno,empname,exec spname
from tablename.

but function we can call with in a query.

Eg:

select empno,empname,upper(empaddress)
from emptable

Answer / mohammed

Yes we can

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

We need to perform what steps in the following order to work with a cursor?

0 Answers  

---

Can an entity have two primary keys?

0 Answers  

---

Explain isolation levels that sql server supports?

0 Answers  

---

Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,

---

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers  

---

How to set database to be single_user in ms sql server?

0 Answers  

---

What do we need queues in sql service broker?

0 Answers  

---

What do you understand by mirroring?

0 Answers  

---

What is sql collation?

0 Answers  

---

What is role playing dimension with two examples? : sql server analysis services, ssas

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---