can we call stored Procedure in Function in Sql Server 2000
and vice versa.
- 3 Answers
- 18103 Views
- C3I, eSoft, iPRO Solutions, Wipro, I also Faced
- E-Mail Answers
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 |
Does an index slow down updates on indexed columns?
What is a functions and types in sql server?
What is the use of DBCC commands?
What is row_number()?
What do you understand by the analysis services in sql server?
How to sort the query output with order by clauses in ms sql server?
In the primary key have a multiple field or not?
Is BCNF better than 2NF & 3NF? Why?
0 Answers Akamai Technologies,
What is a primary key?
What is scheduled job and how to create it?
What is a trigger and its types?
What is service broker?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
