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

plss anybody specify tha constrian management system in dbms

2150

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1033

---

What are policy management terms?

984

---

What is the main purpose of having conversation group?

898

---

How can you set the threshold at which sql server will generate keysets asynchronously?

986

---

Write the SQL query to drop, truncate and delete table.

973

---

How do I create a stored procedure in sql server?

1034

---

Explain the first normal form(1nf)?

1023

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

984

---

What are the different authentication modes in sql server? How can it be changed?

1087

---

What is side by side migration in sql server?

1103

---

Define indexes?

1041

---

How to optimize stored procedures in sql server?

1185

---

How do you test your database? : sql server database administration

1020

---

How to view existing indexes on an given table using sys.indexes?

1091

---