can we call stored Procedure in Function in Sql Server 2000
and vice versa.
- 3 Answers
- 18413 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 |
How to delete a login name in ms sql server?
what types of replication are supported in sql server? : Sql server database administration
What is the recursive stored procedure in sql server?
Define Joins?
What is sql language?
What is bcp? When does it use?
where can you add custom error messages to sql server? : Sql server administration
What is merge?
What stored by the tempdb ? : sql server database administration
How to join two tables in a single query in ms sql server?
What is lookup override?
What are the new data types are introduced in sql 2000?
-
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)
