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

What happens when the SQL Azure database reaches Max Size?

107

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

926

---

How do you delete a trigger?

919

---

How to delete multiple rows with one delete statement in ms sql server?

943

---

What is report subscription?

117

---

What is dbcc command in sql server?

1021

---

What are “lock” hints?

999

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2160

---

How do I get to sql server configuration manager?

953

---

What do you mean by tablesample?

1035

---

What is the advantage of sql server?

989

---

Do you know the capabilities of cursors?

1077

---

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

147

---

What is single-user mode?

871

---

Show Practically Sql Server Views are updatable?

1056

---