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

How many types of cursor type are there?

1162

What is difference between inner join and full join?

1110

What are the differences between decimal and float in ms sql server?

1343

How does the report manager work in SSRS?

158

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

1121

What are the types of dml?

1025

Does a full backup include transaction log?

1045

What is catalog views?

1117

How to create a testing table with test data in ms sql server?

1139

How to define and use table alias names in ms sql server?

1208

How to get the definition of a trigger back?

1044

Write a query to find 5th highest amount paid from the customer table.

985

What are the difference between primary keys and foreign keys?

1010

Is it possible to call a stored procedure within a stored procedure?

1025

What is the difference between count and distinct count?

927