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

What is sqlcmd?

961

---

What are Row versions of DataRow?

974

---

What happens if strings are casted into wrong code pages in ms sql server?

1063

---

Can we write a distributed query and get some data which is located on other server and oracle database?

1176

---

What is deploy, process and build? : sql server analysis services, ssas

1034

---

What is ssl in sql server?

1011

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

856

---

What is a deadlock and what is a live lock?

951

---

How do I find information about the install locations for the various instances running on a computer?

1031

---

what are different types of backups available in sql server? : Sql server database administration

890

---

What is data file in computer?

892

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

988

---

What is sql server replication? : sql server replication

923

---

What is service broker?

955

---

What are the commands used in DCL?

965

---