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

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

969

---

What is the tcp/ip port on which sql server runs?

1166

---

Explain what are commit and rollback in sql?

937

---

Describe how to use linked server?

1025

---

How to include date and time values in sql statements?

1090

---

Explain filtered indexes?

1006

---

How do I start sql server 2016?

915

---

What is the sql case statement used for? Explain with an example?

999

---

What is SQL Azure Federations?

112

---

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

191

---

How does Report Builder support Analysis Services cubes?

156

---

Distinguish between commit and rollback?

968

---

define and explain the differences between clustered and non-clustered indexes.

1198

---

What is “asynchronous” communication in sql server service broker?

1040

---

What is the default port for SQL Server over a firewall?

1103

---