can we call stored Procedure in Function in Sql Server 2000
and vice versa.
Answers were Sorted based on User's Feedback
Answer / rvs varma
Its not possible to call sp's in function but viceversa is
possible
| Is This Answer Correct ? | 63 Yes | 6 No |
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 |
What are the disadvantages of indexes?
How to define the name and server for a new dsn?
What is the difference between set and select?
When would you use a before or after trigger?
Why do you want to join software field as you have done your BE in Electronics?
About Indexed Views? with example? plz reply...
What should we do to copy the tables, schema and views from one SQL Server to another?
What is the difference between Procedure and Function
4 Answers Accenture, Nagarro, TCS,
What are the methods used to protect against sql injection attack?
How many types of database relationship in sql server?
How do I find the sql server version?
Why variables called the most powerful component of ssis?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)