can we call stored Procedure in Function in Sql Server 2000
and vice versa.

Answer Posted / mohammad ali

We cannot call Procedure from the Function

We can call the Procedure From the Procedure as
EXEC ProcedureName
@Parameter1 = "Para1"
@Parameter2 = "Para2"
@Parameter3 = @Val OUTPUT (Use when there is Output in the Procedure)

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you move the resources after pausing the node? : sql server database administration

594


Explain what is the difference between a local and a global temporary table?

513


What is the exact numeric data type in sql?

547


Does windows server 2016 come with sql server?

498


Explain differentiate between a having clause and a where clause?

511






What happens if an integer is too big for int date type?

575


When I delete any data from a table, does the sql server reduce the size of that table?

580


What is a constant or literal in ms sql server?

592


What are horizontal and vertical scaling?

144


What is sqlservr.exe - process - sql server (sqlex?press)?

598


Explain primary key in sql server?

565


What is tcl in sql server?

663


What are points to remember while using the fillfactor argument?

528


What happens if date-only values are provided as date and time literals?

541


What are locks in sql?

536