We can't call sp inside query insted we can call Function inside que

Can we call SP inside a query?

Question Posted / sachin

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

Is This Answer Correct ?

45 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain data warehousing in sql server?

1048

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1263

What is an execution plan? When would you use it?

978

What are sp_configure commands and set commands?

1022

What are acid properties of transaction?

949

What is a join in sql? What are the types of joins?

1104

Explain sql server authentication modes?

1128

What is a cache in ssrs?

134

What is trigger in salesforce?

983

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1086

How to use values from other tables in update statements in ms sql server?

1117

To which devices can a backup be created and where should these devices be located? : sql server management studio

1043

What is Cross Join and in which scenario do we use Cross Join?

1013

What are the disadvantages of primary key and foreign key in SQL?

1116

What is the server name in sql server?

1010